7 Replies Latest reply on May 14, 2018 8:43 PM by Elmurat Bavlankulov

    How to group dynamic date range into one row as a row header?

    Elmurat Bavlankulov

      Hi All,


      I have created a date selector [Date Parameter]. User will pick one date, and the dashboard will automatically show figures for: yesterday, before yesterday and last week (last 7 days from selected date) and previous week (last 7 days from last week).


      So I used calculated field to create those date ranges, for example Last Week is:



      datediff('day',[Dim Bookingdate Id],[Date Parameter]) <= 7


      datediff('day',[Dim Bookingdate Id],[Date Parameter]) > 0

      then [Dim Bookingdate Id] END


      And when I use them in the dashboard (weekly date ranges), it is showing date by date. For example if I choose 17-APR-18. It will show each date 16th, 15th, 14th, 13th, 12th, 11th and 10th of April.


      But I need week figures to show in one row for 10-16 April and for last week and 09-03 April for previous week.


      And I also need to compare them by %, previous week and last week, in the next row.


      So can anybody help me with this?


      Thanks in advance for your replies.