3 Replies Latest reply: Sep 24, 2015 6:56 AM by Kumar Pramod RSS

    difference in counts

      Hi all,


      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.