I have a metric that uses ago functions to calculate “% Change Year over Year” for a metric. I get [nQSError: 22044] Nesting of AGO or TODATE functions with differing level arguments is not supported.. even though I don't have any nested time series functions.
Here's a pesudocode of my metric definition:
( ifnull(AGO(BaseMetric, TimeHieararchy.Year , 0),0) - ifnull( AGO(BaseMetric, TimeHieararchy.Year , 1),0)) / AGO(BaseMetric , TimeHieararchy.Year , 1)
The BaseMetric is just a distinct count on another column.
Why does OBIS think I have nested time series functions at different levels when all my time arguments are at ‘Year’ level?