Forum Discussion
Time calculations
Hi,
I'd like to calculate window-over-window change in my report.
There are three windows, January, February and July.
The january window is only January, February window is between Feb 1st tot June 30th, July window is between July 1st and December 31st. I want to compare these windows to the previous years, as well as to be able to compare the months in the respective window to the same month the year before.
| Window | Total Sales | Total sales previous period (2021) | |||
| 2022-JAN | 1 000 | 800 | |||
| January | 1 000 | 800 | |||
| 2022-Feb | 500 | 1000 | |||
| February | 100 | 200 | |||
| March | 100 | 200 | |||
| April | 100 | 200 | |||
| May | 100 | 200 | |||
| June | 100 | 200 | |||
Due to these windows having different lenght, I haven't really been able to crack how to set up my time intelligence accordingly.
Any help would be very appreciated
Hi Anonymous,
I'd like to suggest you use the date function to extract the current date as a variable to calculate the previous date ranges, then you can simply use these 'date ranges' as conditions to filter on your table to get corresponding results. (date function does not require a calendar table and can simply nest and custom the filter ranges)
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
1 Reply
Hi Anonymous,
I'd like to suggest you use the date function to extract the current date as a variable to calculate the previous date ranges, then you can simply use these 'date ranges' as conditions to filter on your table to get corresponding results. (date function does not require a calendar table and can simply nest and custom the filter ranges)
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng