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

    From UNITApedia
    No edit summary
    Tag: Reverted
    No edit summary
     
    (5 intermediate revisions by the same user not shown)
    Line 1: Line 1:
    {{#get_db_data:  
    {{#get_db_data:  
    db=DW_UNITAData_Mobility_T241Unito_sum
    db=DW_UNITAData_Mobility
    |data=id=id,
    |query=SELECT jsontext FROM your_json_table WHERE university = 'UNITO'
          type_of_mobility=type_of_mobility,
    |data=record=jsontext
          status_of_mobility_participant=status_of_mobility_participant,
          academic_year=academic_year,
          participants=participants,
          mobility_flux=mobility_flux
    }}
    }}


    {{#store_external_table: DW_UNITAData_Indicators_T241Unito
    {{#echarts:  
    |id={{{id}}}
    |width=1000px|height=600px
    |type_of_mobility={{{type_of_mobility}}}  
    |option={
    |status_of_mobility_participant={{{status_of_mobility_participant}}}
      "title": { "text": "Mobility Participants by Year (UNITO)" },
    |academic_year={{{academic_year}}}  
      "tooltip": { "trigger": "axis" },
    |participants={{{participants}}}  
      "xAxis": {  
    |mobility_flux={{{mobility_flux}}}
        "type": "category",
    }}
        "data": [ {{#for_external_table: , | "{{{record.Academic_year}}}" }} ]
     
      },
    {{#ask: [[-Has subobject::{{FULLPAGENAME}}]]
      "yAxis": { "type": "value" },
    |?id
      "series": [{
    |?type_of_mobility
        "name": "Participants",
    |?status_of_mobility_participant
        "type": "bar",
    |?academic_year
        "data": [ {{#for_external_table: , | {{{record.Participants}}} }} ]
    |?participants
      }]
    |?mobility_flux
    }
    |class=datatable
    |format=datatables
    |mainlabel=-
    |header=show
    }}
    }}

    Latest revision as of 12:42, 4 June 2026