Given the following tables
Studies:
load * inline [
study_country,plan_date,plan_count
3_usa,jan-2018,5
3_usa,feb-2018,7
3_usa,mar-2018,10
];
Sites:
load * inline [
study_country,study_site
3_usa,3_boston
3_usa,3_chicago
3_usa,3_philly
];
Subjects:
load * inline [
study_site,subj,enroll_date
3_boston,andy,jan-2018
3_boston,clara,feb-2018
3_philly,janet,feb-2018
];
Is it possible to render a line chart with plan_date as the dimension and two measures:
1) sum(plan_count) // the planned enrollment for the study_country on any given plan_date.
2) a count of subjects who enrolled on the plan_date; ie enroll_date=plan_date
Thanks.
