Does this post address your use case? https://community.sisense.com/t5/knowledge/compare-a-time-window-against-the-immediately-preceding-time/ta-p/8856
In my example, following the example provided, I inputted the Days in Date filter but I have not selected a day range.
In the new updated version of Sisense, we have this screen to choose from when filtering for Days in Date. It is not the same as the example, but I assume I can pick the last 30 days in this filter. I added the script and tried picking 30 days, but it still shows the same values compared to the widget that does not have a filter or the script. As shown in the last picture.
The difference in numbers for the 2nd part of the indicator widget is due to choosing 30 days within the widget in the 2nd formula.
I have chosen the a weeks timeframe and it is not showing me the previous timeframe.
Hi Astroraf.
Thank you for getting back to me. At this point let's get a support case open. They will either be able to find a solution or determine that a technical consultant is needed. Go ahead and link this post when creating the support case so they can reference it.
