Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Let us take and example:-
1. If you are selecting 16/08/2022 as Date, it is Tuesday so I want to display Tuesday data (sum value) for past 8 weeks like 16/08, 09/08, 02/08, 26/07, 19/07, 12/07, 05/07, 28/06
2. If you select 11/08/2022 which was Thursday, so it should display 11/08, 04/08, 28/07, 21/07, 14/07, 07/07, 30/06, 23/07
You may use something like:
sum({< Date = {">=$(max(Date)-56)<=$(max(Date))"}, WeekDay = {"$(=max(WeekDay)"}>} Value)
- Marcus