DataSrc:T241b

{{#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}}} }}

option = {

 title: { text: 'BIP Mobilities by Month' },
 tooltip: {
   trigger: 'axis',
   axisPointer: { type: 'cross', label: { backgroundColor: '#6a7985' } }
 },
 dataset: {
   source: [
 [
   "entry_date",
   "Student bachelor",
   "Student master",
   "Student doctorate"
 ],

 [
   "2023-11-01",
   8, 1,
   1, 4,
   1
 ],

 [
   "2023-12-01",
   8,
   1,
   1
 ],

 [
   "2024-01-01",
   11,
   1,
   1
 ],

 [
   "2024-02-01",
   18,
   2, 1,
   2
 ],

 [
   "2024-03-01",
   5, 15,
   2, 1,
   3
 ],

 [
   "2024-04-01",
   15, 8,
   2, 3, 1,
   3
 ],

 [
   "2024-05-01",
   15, 20,
   5, 2, 1,
   2, 1
 ],

 [
   "2024-06-01",
   4, 12,
   6, 2,
   4
 ],

 [
   "2024-07-01",
   19, 1, 11,
   2, 3, 2,
   2, 4
 ],

 [
   "2024-08-01",
   7, 1,
   1, 2, 2,
   5
 ],

 [
   "2024-09-01",
   8,
   4, 2,
   1
 ],

 [
   "2024-10-01",
   12, 9,
   6, 4,
   
 ],

 [
   "2024-11-01",
   18, 9,
   5, 13,
   1, 1
 ]

]

 },
 xAxis: { type: 'category' },
 yAxis: { type: 'value' },
 series: [
   { type: 'line', stack: 'total', areaStyle: {} },
   { type: 'line', stack: 'total', areaStyle: {} },
   { type: 'line', stack: 'total', areaStyle: {} }
 ]

}