3 Replies Latest reply: Sep 25, 2015 2:57 PM by Camile Johnson RSS

    last one week data

      Hi all,




      I need to display last one week data.

      For example: Today is 25th i need to show last one week means from  18th to 24th.


      Currently I am using,

      Dimension as : Week_group


      Measures as:

      1.COUNT({<weekstart={">$(=date(max(weekstart)-7))<=$(=max(weekstart))"}, DateType={invitation}>}invitation_id)

      2. COUNT({<weekstart={">$(=date(max(weekstart)-7))<=$(=max(weekstart))"}, DateType={signed}, user_signed={1}>}invitation_id)


      but this is displaying the data of last week taking monday as weekstart.


      anyone explain how can i display last 7 days/last week in single bar.