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

Latest revision as of 12:42, 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_T241Unito_sum
+db=DW_UNITAData_Mobility
-|data=id=id,
+|query=SELECT jsontext FROM your_json_table WHERE university = 'UNITO'
-      type_of_mobility=type_of_mobility,
+|data=record=jsontext
-      status_of_mobility_participant=status_of_mobility_participant,
-      academic_year=academic_year,
-      participants=participants,
-      mobility_flux=mobility_flux
 }}
-{{#store_external_table: DW_UNITAData_Indicators_T241Unito
+{{#echarts:
-|id={{{id}}}
+|width=1000px|height=600px
-|type_of_mobility={{{type_of_mobility}}}
+|option={
-|status_of_mobility_participant={{{status_of_mobility_participant}}}
+  "title": { "text": "Mobility Participants by Year (UNITO)" },
-|academic_year={{{academic_year}}}
+  "tooltip": { "trigger": "axis" },
-|participants={{{participants}}}
+  "xAxis": {
-|mobility_flux={{{mobility_flux}}}
+    "type": "category",
-}}
+    "data": [ {{#for_external_table: , | "{{{record.Academic_year}}}" }} ]
+  },
-{{#ask: [[-Has subobject::{{FULLPAGENAME}}]]
+  "yAxis": { "type": "value" },
-|?id
+  "series": [{
-|?type_of_mobility
+    "name": "Participants",
-|?status_of_mobility_participant
+    "type": "bar",
-|?academic_year
+    "data": [ {{#for_external_table: , | {{{record.Participants}}} }} ]
-|?participants
+  }]
-|?mobility_flux
+}
-|class=datatable
-|format=datatables
-|mainlabel=-
-|header=show
 }}