DataSrc:T241b: Difference between revisions

    From UNITApedia
    No edit summary
    No edit summary
     
    (30 intermediate revisions by 2 users not shown)
    Line 1: Line 1:
    {{#get_db_data:  
    {{#get_db_data:  
    db=DW_UNITAData_T241b
    db=DW_UNITAData_T241b
    |data=id=id,type_of_mobility=type_of_mobility,status_of_mobility_participant=status_of_mobility_participant,monthyear=monthyear,participants=participants
    |data=id=id,type_of_mobility=type_of_mobility,status_of_mobility_participant=status_of_mobility_participant,entry_date=monthyear,participants=participants
    }}
    }}


    Line 8: Line 8:
    |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}}}
    |monthyear={{{monthyear}}}  
    |entry_date={{{entry_date}}}  
    |participants={{{participants}}}  
    |participants={{{participants}}}  
    }}
    }}
    Line 16: Line 16:
    |?type_of_mobility
    |?type_of_mobility
    |?status_of_mobility_participant
    |?status_of_mobility_participant
    |?monthyear
    |?entry_date
    |?participants
    |?participants
    |class=datatable  
    |class=datatable  
    Line 24: Line 24:
    }}
    }}


    {{#ask:
     
    [[-Has subobject::DataSrc:t241b]] <!-- or whatever subobject / condition you use -->
    {{#vardefine: t241dateData |
    |?monthyear
    [
    |?participants
      [
    |?status_of_mobility_participant <!-- The property you want to split into different series -->
        "entry_date",
    |format=timeseries
        "Student bachelor",
    |link=none
        "Student master",
    |xprop=monthyear
        "Student doctorate"
    |yprop=participants
      ],
    |group=status_of_mobility_participant  <!-- Group by mobility type, so each type is a separate series -->
     
    |layout=area              <!-- Area chart -->
      [
    |accumulate=true          <!-- Stack the areas -->
        "Nov 2023",
    |sort=monthyear
        {{#ask:
    |order=ascending
          [[-Has subobject::{{FULLPAGENAME}}]]
    |limit=50
          [[entry_date::2023-11-01]]
    |headers=show
          [[type_of_mobility::BIP-student mobility for studies]]
    |charttitle=BIP Mobilities
          [[status_of_mobility_participant::Student bachelor]]
    |zoomarea=bottom
          |?participants
    |tablearea=bottom
          |format=plain
    |class=sortable wikitable smwtable
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2023-11-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2023-11-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "Dec 2023",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2023-12-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2023-12-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2023-12-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "Jan 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-01-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-01-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-01-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "Feb 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-02-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-02-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-02-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "Mar 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-03-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-03-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-03-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "Apr 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-04-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-04-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-04-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "May 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-05-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-05-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-05-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "Jun 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-06-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-06-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-06-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "Jul 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-07-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-07-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-07-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "Aug 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-08-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-08-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-08-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
       ],
     
      [
        "Sep 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-09-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-09-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-09-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "Oct 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-10-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-10-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-10-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ],
     
      [
        "Nov 2024",
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-11-01]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-11-01]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }},
        {{#ask:
          [[-Has subobject::{{FULLPAGENAME}}]]
          [[entry_date::2024-11-01]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=plain
          |headers=hide
          |link=none
          |mainlabel=-
        }}
      ]
    ]
    }}
     
    {{#echarts:
    width=1000px |
    height=600px |
    option = {
      title: {
        text: 'BIP-student mobility for studies'
      },
      tooltip: {
        trigger: 'axis',
        axisPointer: {
          type: 'shadow'
        }
      },
      toolbox: {
        feature: {
          magicType: {
            type: ["line", "bar","stack"]
          },
          saveAsImage: {},
        }
      },
      legend: {
        data: ['Student bachelor', 'Student master', 'Student doctorate']
      },
      grid: {
        left: '3%',
        right: '4%',
        bottom: '3%',
        containLabel: true
      },
      dataset: {
        source: {{#var:t241dateData}}
      },
      xAxis: {
        type: 'category'
      },
      yAxis: {
        type: 'value'
      },
      series: [
        {
          type: 'bar',
          stack: 'total',
          emphasis: { focus: 'series' }
        },
        {
          type: 'bar',
          stack: 'total',
          emphasis: { focus: 'series' }
        },
        {
          type: 'bar',
          stack: 'total',
          emphasis: { focus: 'series' }
        }
      ]
    }
    }}
    }}

    Latest revision as of 14:50, 2 April 2025