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

@@ Line 1: / Line 1: @@
 {{#get_db_data:
-db=DW_UNITAData_Mobility
+db=DW_UNITAData_Indicators_T241Unito
-|query=SELECT jsontext FROM your_json_table WHERE university = 'UNITO'
+|data=id=id,type_of_mobility=type_of_mobility,status_of_mobility_participant=status_of_mobility_participant,entry_date=monthyear,participants=participants
-|data=record=jsontext
 }}
-{{#echarts:
+{{#store_external_table: DW_UNITAData_Indicators_T241Unito
-|width=1000px|height=600px
+|id={{{id}}}
-|option={
+|type_of_mobility={{{type_of_mobility}}}
-  "title": { "text": "Mobility Participants by Year (UNITO)" },
+|status_of_mobility_participant={{{status_of_mobility_participant}}}
-  "tooltip": { "trigger": "axis" },
+|entry_date={{{entry_date}}}
-  "xAxis": {
+|participants={{{participants}}}
-    "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
-|data=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 37: / Line 16: @@
 |?type_of_mobility
 |?status_of_mobility_participant
-|?academic_year
+|?entry_date
 |?participants
-|?mobility_flux
 |class=datatable
 |format=datatables

Revision as of 12:38, 4 June 2026