Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 to...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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