DataSrc:T241b: Difference between revisions

    From UNITApedia
    No edit summary
    No edit summary
    Line 25: Line 25:


    {{#ask:
    {{#ask:
      [[-Has subobject::{{FULLPAGENAME}}]] <!-- or whatever subobject / condition you use -->
      [[-Has subobject::{{FULLPAGENAME}}]]
      |?entry_date
      |?entry_date
      |?participants
      |?participants
      |?status_of_mobility_participant <!-- The property you want to split into different series -->
      |?status_of_mobility_participant
      |format=timeseries
      |format=timeseries
      |link=none
      |link=none
      |xprop=entry_date
      |xprop=entry_date
      |yprop=participants
      |yprop=participants
      |group=status_of_mobility_participant   <!-- Group by mobility type, so each type is a separate series -->
      |group=status_of_mobility_participant
      |layout=area               <!-- Area chart -->
      |layout=area
      |accumulate=true           <!-- Stack the areas -->
      |accumulate=true
      |sort=entry_date
      |sort=entry_date
      |order=ascending
      |order=ascending
    Line 45: Line 45:
      |class=sortable wikitable smwtable
      |class=sortable wikitable smwtable
    }}
    }}
    {{#ask:  [[-Has subobject::{{FULLPAGENAME}}]]  
    {{#ask:  [[-Has subobject::{{FULLPAGENAME}}]]  
    |?entry_date
    |?entry_date

    Revision as of 13:47, 28 March 2025

    {{#get_db_data: db=DW_UNITAData_T241b |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_T241b |id={{{id}}} |type_of_mobility={{{type_of_mobility}}} |status_of_mobility_participant={{{status_of_mobility_participant}}} |entry_date={{{entry_date}}} |participants={{{participants}}} }}