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

    difference in counts

    Kumar Pramod

      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.

       

      Dimension:

      weekGroup

       

      Measures:

      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.

       

       

      Thanks,

      Pramod