7 Replies Latest reply: May 4, 2015 9:13 AM by Peter Cammaert RSS

    last 4 weeks data in bar graph

    Kumar Pramod

      Hi all,

       

      I have a data like below. i need the results in bar graph.

       

      invitation_id    date_created  user_signed  course_completed  

      1                  02-04-2015             1                   1

      2                  12-04-2015             1                   1

      3                  20-04-2015             0                   0

      4                  25-04-2015             1                   1

      5                  26-04-2015             1                   0

      6                  27-04-2015             1                   1

      7                  28-04-2015             1                   0

      8                  29-04-2015             1                    1

      9                  01-05-2015             1                   1

      10                02-05-2015             1                   1

      11                03-05-2015              1                   1

      12                03-05-2015              1                 0

       

       

      i am using measures like:

      1. count({$<course_completed={1}>}[invitation_id])

      2. count({$<user_signed={1}>}[invitation_id])

      3. count(invitation_id)

       

      I need bar graph on week basis. last 4 weeks data.

       

      and also for last 7 days. please help me.

       

      Untitled.png

       

       

      Thanks,

      Pramod