09-28-2016 05:47 AM
Is there anyway to create day wise data through Periodic function (like Relative Period, Parallel Period, Cumulative, Parallel, PeriodwithDate...) in SAS Visual Analytics?
I have dataset like this in LASR Server
and i want day wise comparison current date to previous date...
Date Revenue Previous Revenue
24-Sep-2016 $70 $20
25-Sep-2016 $80 $10
26-Sep-2016 $90 $40
27-Sep-2016 $16 $50
28-Sep-2016 $25 $60
Sunny Kumar Gupta
10-03-2016 02:32 AM
10-03-2016 05:19 AM
There are only three specifics interval i.e _ByMonth_, _ByQuarter_, _ByYear_ but there were no any _ByDay_ interval option available.
10-03-2016 07:21 AM
10-03-2016 09:36 AM
Day-wise interval can be used when your inner interval is set to _Inferred_.
However, as I understand it there are some technical issues calculating day-wise data over time. If your operator has an offset (like your example with RelativePeriod would have) then we return missing values.
I think this is something we are working to improve for the future.