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

    last one week data

    Kumar Pramod

      Hi all,

       

      gwassenaar

       

      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.

       

      Thanks,

      Pramod