2016-04-16 12:04 AM
Have used the folloing 'filter' definition in numerous reports to limit data pulled from performance and other datamarts but working with the Node Performance DM and this same filer is failing as the report returns no data but I can do tabular query and all the info is there.
[Full Date] between _add_days (current_date, -1) and current_date
No idea what [Full Date] in this DM would respond differently to the Capacity DMs or anything else that hold time series of data points??
2016-04-16 01:19 AM
So after many different combinations I found that [Full Date] > _add_days (current_date, -1) worked ok...
I've had the same issue working trying to get a time window for say the last 6hrs... again I've tried various combinations but things like below don't seem to work.
[Time] > _add_hours ([Time], -6)
2016-04-16 07:48 AM
There are a few reasons I wouldn't expect success with the "last 6 hours" concept.
You might do better to look for the 6 newest data points in the hourly performance facts.