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:

       

      if

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

      and

      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.