Using one field's value to select records from another table.

[stascher]

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.

[ogautier62 · Accepted solution]

Hi

is this you're expecting ?

regards

[stascher]

Thank you.