Hi I am trying to create following dashboard
I want to show 3 metrics Sales, orders, and units sold for 7 days of data in reverse order. Data always start from Yesterday, for example, today is 15-Feb-2024, so dashboard will start from yesterday which is 14-Feb-2024. So there is
Yesterday, 14-Feb
next column => previous 6 days (13 Feb - 8 Feb ),
next column => Same day (Last week) 07-Feb ( this is with respect first column “Yesterday” )
next column => Last 7 days (cumulative) 08th Feb - 14th Feb
next column => Month to date (cumulative) 01st Feb - 14th Feb
I tried to generate by putting filter on “day” field on dataset , then swap rows&columns and applying sorting to descending order which returns data but it restricts data from 07-Feb to 14-Feb
What are possible ways to implement this view/dashboard?
Also as per first image, how to show 2 level headers such as yesterday then (date below it), last 6 days ( dates below it ), Same day (Last week) … etc
Please provide guidance on this.