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

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