DataSrc:UNITA Data/Indicators/t241hesso

option = {

 baseOption: {
   timeline: { axisType: 'category', data: ['2023-2024', '2024-2025'], autoPlay: false },
   tooltip: { trigger: 'axis', axisPointer: { type: 'shadow' } },
   legend: { top: '5%' },
   grid: { top: '20%', left: '3%', right: '4%', bottom: '25%', containLabel: true },
   xAxis: {
     type: 'category',
     name: 'Type of Mobility',
     axisLabel: { rotate: 35, interval: 0 },
     data: ['Matching Event (Research, Education etc)','other- staff week, workshop, conference, training, internship, research','SMS-student mobility for studies','SMT-student mobility for traineeship','STT-staff mobility for training','UNITA Week meeting','Work Package meeting','BIP-student mobility for studies','STA-staff mobility for teaching','URM-Rural Mobility','UVM-Virtual Mobility']
   },
   yAxis: { type: 'value', name: 'Participants' },
   series: [
     { name: 'Staff academic', type: 'bar', stack: 'total' },
     { name: 'Staff administrative', type: 'bar', stack: 'total' },
     { name: 'Student bachelor', type: 'bar', stack: 'total' },
     { name: 'Student master', type: 'bar', stack: 'total' },
     { name: 'Student doctorate', type: 'bar', stack: 'total' },
     { name: 'Researcher', type: 'bar', stack: 'total' },
     { name: 'Student Assembly member', type: 'bar', stack: 'total' }
   ]
 },
 options: [
   {
     series: [
       { data: [18, 1, 0, 0, 1, 0, 1, 0, 0, 0, 0] },
       { data: [2, 4, 0, 0, 2, 16, 17, 0, 0, 0, 0] },
       { data: [0, 0, 3, 0, 0, 1, 0, 0, 0, 0, 0] },
       { data: [0, 4, 0, 3, 0, 0, 0, 0, 0, 0, 0] },
       { data: [0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0] },
       { data: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] },
       { data: [0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0] }
     ]
   },
   {
     series: [
       { data: [22, 9, 0, 0, 0, 0, 0, 0, 10, 0, 0] },
       { data: [4, 27, 0, 0, 0, 9, 2, 0, 0, 0, 0] },
       { data: [0, 4, 6, 0, 0, 0, 0, 34, 0, 2, 7] },
       { data: [0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 7] },
       { data: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2] },
       { data: [0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0] },
       { data: [0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0] }
     ]
   }
 ]

}

{{#get_db_data: db=DW_UNITAData_Mobility_T241Hesso_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_T241Hesso_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}}} }}