DataSrc:UNITA Data/Indicators/t241unito

1. 1. 1. 1. 1. 1. 1. 1. 1. 1. 1. 1. SOURCE 1: RAW JSON FOR THE GRAPH ############

{{#get_db_data: db=DW_UNITAData_Mobility |data=jsontext=jsontext, university=university }}

{{#store_external_table: DW_UNITAData_Mobility_Raw |jsontext={{{jsontext}}} }}

1. 1. 1. Mobility Visualization

option = {

 legend: { top: '5%' },
 tooltip: { trigger: 'axis', axisPointer: { type: 'shadow' } },
 dataset: {
   source: [ {{#for_external_table:
 {{{jsontext}}}

}} ]

 },
 xAxis: { type: 'category', name: 'Type of Mobility', axisLabel: { rotate: 20, interval: 0 } },
 yAxis: { type: 'value', name: 'Participants' },
 grid: { top: '15%', left: '3%', right: '4%', bottom: '20%', containLabel: true },
 series: [
   { name: 'Student bachelor', type: 'bar', encode: { x: 'Type_of_mobility', y: 'Participants' }, filter: { Status_of_mobility_participant: 'Student bachelor' } },
   { name: 'Student master', type: 'bar', encode: { x: 'Type_of_mobility', y: 'Participants' }, filter: { Status_of_mobility_participant: 'Student master' } },
   { name: 'Student doctorate', type: 'bar', encode: { x: 'Type_of_mobility', y: 'Participants' }, filter: { Status_of_mobility_participant: 'Student doctorate' } },
   { name: 'Student Assembly member', type: 'bar', encode: { x: 'Type_of_mobility', y: 'Participants' }, filter: { Status_of_mobility_participant: 'Student Assembly member' } }
 ]

}

---

1. 1. 1. 1. 1. 1. 1. 1. 1. 1. 1. 1. SOURCE 2: SUMMED VIEW FOR THE DATATABLE ############

{{#get_db_data: db=DW_UNITAData_Mobility_T241Unito_sum |data=academic_year=academic_year,type_of_mobility=type_of_mobility, status_of_mobility_participant=status_of_mobility_participant, participants=participants, mobility_flux=mobility_flux }}

{{#store_external_table: DW_UNITAData_Mobility_T241Unito_sum |academic_year={{{academic_year}}} |type_of_mobility={{{type_of_mobility}}} |status_of_mobility_participant={{{status_of_mobility_participant}}} |participants={{{participants}}} |mobility_flux={{{mobility_flux}}} }}

1. 1. 1. Mobility Data Table