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

    From UNITApedia
    No edit summary
    No edit summary
    Line 1: Line 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}}}
    }}
    {{#vardefine:jsondata|{{#for_external_table:
      {{{jsontext}}}
    }}}}
    ### Mobility Visualization
    {{#echarts:
    width=1000px |
    height=600px |
    option = {
      legend: { top: '5%' },
      tooltip: { trigger: 'axis', axisPointer: { type: 'shadow' } },
      dataset: {
        source: [ {{#var:jsondata}} ]
      },
      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' } }
      ]
    }
    }}
    ---
    ############ SOURCE 2: SUMMED VIEW FOR THE DATATABLE ############
    {{#get_db_data:  
    {{#get_db_data:  
    db=DW_UNITAData_Mobility_T241Unito_sum
    db=DW_UNITAData_Mobility_T241Unito_sum
    Line 12: Line 50:
    |mobility_flux={{{mobility_flux}}}  
    |mobility_flux={{{mobility_flux}}}  
    }}
    }}
    ### Mobility Data Table
    {{#ask: [[-Has subobject::{{FULLPAGENAME}}]]
    {{#ask: [[-Has subobject::{{FULLPAGENAME}}]]
    |?academic_year
    |?academic_year

    Revision as of 15:27, 11 June 2026

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




        1. Mobility Visualization

    ---

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



        1. Mobility Data Table