DataSrc:UNITA Data/Indicators/t241unito: Difference between revisions

Revision as of 12:38, 4 June 2026

|option={

 "title": { "text": "Mobility Participants by Year (UNITO)" },
 "tooltip": { "trigger": "axis" },
 "xAxis": { 
   "type": "category", 
   "data": [  ] 
 },
 "yAxis": { "type": "value" },
 "series": [{
   "name": "Participants",
   "type": "bar",
   "data": [  ]
 }]

}

@@ Line 1: / Line 1: @@
+{{#get_db_data:
+db=DW_UNITAData_Mobility
+|query=SELECT jsontext FROM your_json_table WHERE university = 'UNITO'
+|data=record=jsontext
+}}
+{{#echarts:
+|width=1000px|height=600px
+|option={
+  "title": { "text": "Mobility Participants by Year (UNITO)" },
+  "tooltip": { "trigger": "axis" },
+  "xAxis": {
+    "type": "category",
+    "data": [ {{#for_external_table: , | "{{{Academic_year}}}" }} ]
+  },
+  "yAxis": { "type": "value" },
+  "series": [{
+    "name": "Participants",
+    "type": "bar",
+    "data": [ {{#for_external_table: , | {{{Participants}}} }} ]
+  }]
+}
+}}
 {{#get_db_data:
 db=DW_UNITAData_Mobility_T241Unito_sum
@@ Line 7: / Line 31: @@
        participants=participants,
        mobility_flux=mobility_flux
-}}
-{{#store_external_table: DW_UNITAData_Indicators_T241Unito
-|id={{{id}}}
-|type_of_mobility={{{type_of_mobility}}}
-|status_of_mobility_participant={{{status_of_mobility_participant}}}
-|academic_year={{{academic_year}}}
-|participants={{{participants}}}
-|mobility_flux={{{mobility_flux}}}
 }}
@@ Line 30: / Line 45: @@
 |header=show
 }}
-<echarts width="1000px" height="600px">
-{
-  "title": { "text": "Mobility Participants by Year" },
-  "tooltip": { "trigger": "axis" },
-  "xAxis": {
-    "type": "category",
-    "data": [ {{#ask: [[-Has subobject::{{FULLPAGENAME}}]] |?academic_year= |format=list |sep=, |link=none}} ]
-  },
-  "yAxis": { "type": "value" },
-  "series": [{
-    "name": "Participants",
-    "type": "bar",
-    "data": [ {{#ask: [[-Has subobject::{{FULLPAGENAME}}]] |?participants= |format=list |sep=, |link=none}} ]
-  }]
-}
-</echarts>