I have one date from each week and data for each date. Date can vary and can not be calculated by adding or subtracting fix number.
I need to show current week vs previous week data.
I created filter for date column. Need help calculating data for previous week by what ever available date.
I am trying to achieve it by giving sequence number to dates. But not able to find right set analysis.
Here is sample code :
AutoNumber(T_Date) As T_DateSeq,
If(AutoNumber(T_Date)=1, AutoNumber(T_Date), AutoNumber(T_Date)-1) As T_PreDateSeq,
Filter Dimension : T_Date
Current Balance : Sum ({T_DateSeq}Current_Balance) )
Previous Balance : Sum ({T_PreDateSeq}Current_Balance) )
I have attached data sample and dashboard visual for reference.
Any suggestion would be really appreciated.
