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

    From UNITApedia
    (Created page with "{{#get_db_data: db=DW_UNITAData_Indicators_T241Uvt |data=id=id,type_of_mobility=type_of_mobility,status_of_mobility_participant=status_of_mobility_participant,entry_date=monthyear,participants=participants }} {{#store_external_table: DW_UNITAData_Indicators_T241Uvt |id={{{id}}} |type_of_mobility={{{type_of_mobility}}} |status_of_mobility_participant={{{status_of_mobility_participant}}} |entry_date={{{entry_date}}} |participants={{{participants}}} }} {{#ask: -Has...")
     
    No edit summary
    Line 1: Line 1:
    {{#echarts:
    height=700px |option = {
      baseOption: {
        timeline: { axisType: 'category', data: ['2023-2024', '2024-2025', '2025-2026'], 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: ['BIP-student mobility for studies','Matching Event (Research, Education etc)','other- staff week, workshop, conference, training, internship, research','SMS-student mobility for studies','SMT-student mobility for traineeship','STA-staff mobility for teaching','STT-staff mobility for training','UNITA Week meeting','URM-Rural Mobility','UVM-Virtual Mobility','Work Package meeting']
        },
        yAxis: { type: 'value', name: 'Participants' },
        series: [
          { name: 'Student bachelor', type: 'bar', stack: 'total' },
          { name: 'Student master', type: 'bar', stack: 'total' },
          { name: 'Student doctorate', type: 'bar', stack: 'total' },
          { name: 'Staff academic', type: 'bar', stack: 'total' },
          { name: 'Staff administrative', type: 'bar', stack: 'total' },
          { name: 'Researcher', type: 'bar', stack: 'total' },
          { name: 'Student Assembly member', type: 'bar', stack: 'total' },
          { name: 'Other', type: 'bar', stack: 'total' }
        ]
      },
      options: [
        {
          series: [
            { data: [56, 0, 1, 10, 0, 0, 0, 0, 1, 0, 0] },
            { data: [22, 0, 0, 0, 0, 0, 0, 0, 4, 1, 0] },
            { data: [4, 0, 1, 0, 13, 0, 0, 0, 0, 0, 0] },
            { data: [0, 21, 31, 0, 0, 25, 33, 13, 0, 0, 13] },
            { data: [0, 2, 2, 0, 0, 0, 43, 6, 0, 0, 14] },
            { data: [0, 0, 1, 0, 0, 0, 2, 0, 0, 0, 0] },
            { data: [0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0] },
            { data: [0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0] }
          ]
        },
        {
          series: [
            { data: [75, 0, 2, 15, 0, 0, 0, 0, 0, 5, 0] },
            { data: [45, 0, 7, 8, 0, 0, 0, 0, 1, 2, 0] },
            { data: [19, 0, 4, 0, 10, 0, 1, 0, 0, 0, 0] },
            { data: [0, 39, 37, 0, 0, 35, 23, 21, 0, 0, 0] },
            { data: [0, 0, 3, 0, 0, 0, 13, 5, 0, 0, 0] },
            { data: [0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0] },
            { data: [0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0] },
            { data: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] }
          ]
        },
        {
          series: [
            { data: [15, 0, 5, 13, 0, 0, 0, 0, 0, 0, 0] },
            { data: [7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] },
            { data: [1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0] },
            { data: [0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 14] },
            { data: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5] },
            { data: [0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0] }
          ]
        }
      ]
    }
    }}
    {{#get_db_data:  
    {{#get_db_data:  
    db=DW_UNITAData_Indicators_T241Uvt
    db=DW_UNITAData_Mobility_T241Uvt_sum
    |data=id=id,type_of_mobility=type_of_mobility,status_of_mobility_participant=status_of_mobility_participant,entry_date=monthyear,participants=participants
    |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_Indicators_T241Uvt
    {{#store_external_table: DW_UNITAData_Mobility_T241Uvt_sum
    |id={{{id}}}  
    |academic_year={{{academic_year}}}  
    |type_of_mobility={{{type_of_mobility}}}  
    |type_of_mobility={{{type_of_mobility}}}  
    |status_of_mobility_participant={{{status_of_mobility_participant}}}
    |status_of_mobility_participant={{{status_of_mobility_participant}}}  
    |entry_date={{{entry_date}}}  
    |participants={{{participants}}}  
    |participants={{{participants}}}  
    |mobility_flux={{{mobility_flux}}}
    }}
    }}
    {{#ask: [[-Has subobject::{{FULLPAGENAME}}]]
    {{#ask: [[-Has subobject::{{FULLPAGENAME}}]]
    |?id
    |?academic_year
    |?type_of_mobility
    |?type_of_mobility
    |?status_of_mobility_participant
    |?status_of_mobility_participant
    |?entry_date
    |?participants
    |?participants
    |class=datatable  
    |?mobility_flux
    |format=datatables  
    |class=datatable
    |mainlabel=-  
    |format=datatables
    |mainlabel=-
    |header=show
    |header=show
    }}
    }}

    Revision as of 08:00, 15 June 2026