Time Comparison

[#1]

Hi All,

My data contain year, month, day and income.

I need to compare Day income to the same day last year, month, quarter....

I have MulteBox for Year, Month and Day selection. When i selectYear, Month, Day i can compare only with the days in the selection month.

For example: if i select 22/02/2016 i can compare only to the last 21 days and i want 356

Thanks for your help

[sunny_talwar]

You can explore using Above() function or using AsOf Table -> The As-Of Table

[swuehl]

You can also look into using set analysis for point in time reporting:

The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync

Not sure why you are only able to compare to days in the same month, could you explain your issue a bit more detailed?