I have attached a . qvf file. Please check and help me to create a master calendar for the date fields present in the tables.
I need to create a bar chart where it has 3 bars, and i need on weekly basis.
1. Count of invitation_id
2. count of invitation_id where landing_page_accessed = 1
3. count of invitation_id where user_signed = 1
4. count of invitation_id where course_completed = 1.
I am not getting how to use different date fields, (date_created, date_signed, date_completed).
if i use single date field the counts are coming properly.
If i use canonical date as date field for weekgroup the values are changing.
Help to create a bar chart of all four measures with exact counts.