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-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: [
 [
   "entry_date",
   "Student bachelor",
   "Student master",
   "Student doctorate"
 ],

 [
   "Nov 2023",
   ,
   1, 4,
   1
 ],

 [
   "Dec 2023",
   8,
   1,
   1
 ],

 [
   "Jan 2024",
   11,
   1,
   1
 ],

 [
   "Feb 2024",
   18,
   2, 1,
   2
 ],

 [
   "Mar 2024",
   5, 15,
   2, 1,
   3
 ],

 [
   "Apr 2024",
   15, 8,
   2, 3, 1,
   3
 ],

 [
   "May 2024",
   15, 20,
   5, 2, 1,
   2, 1
 ],

 [
   "Jun 2024",
   4, 12,
   6, 2,
   4
 ],

 [
   "Jul 2024",
   19, 1, 11,
   2, 3, 2,
   2, 4
 ],

 [
   "Aug 2024",
   7, 1,
   1, 2, 2,
   5
 ],

 [
   "Sep 2024",
   8,
   4, 2,
   1
 ],

 [
   "Oct 2024",
   12, 9,
   6, 4,
   
 ],

 [
   "Nov 2024",
   18, 9,
   5, 13,
   1, 1
 ]

]

 },
 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' }
   }
 ]

}