I've created the following aggregated periodic measure called "Consumed":
But when I try to calculate the average of that measure, I get a message that "Nested aggregated expressions are not supported":
So - how do I calculate the AVERAGE (and the MIN and the MAX)?
Hello @blewsas ,
The problem in your approach is that VA doesn't currently allow nested aggregated expressions i.e. aggregated operators inside aggregated operators.
VA 8.3 introduced capability to create an aggregated data source which allows us to create Consumed Avg, Consumed Min and Consumed Max without using nested aggregated operators. Although this approach has caveats like needing to define categories beforehand and possibly needing to Join the data to others for report actions to work.
Create aggregated data source
Now your new data source has a measure Consumed of which aggregation you can define normally to be sum/avg/min/max etc...
Maybe this approach would work for you?
Thanks for your reply. I thought about that approach too, but it doesn't seem to work. 😕
Here are my data items after I created the "Consumed" item using the calculation I previously posted.
However, when I create a new aggregated data source from this data source, "Consumed" is not one of the available items:
You are correct, that indeed seems to be the case. I did some testing and it appears that Aggregated Data Sources support f.ex. Aggregated (simple) and Aggregated (advanced) operators but not the Aggregated (periodic) operators.
Unfortunately I do not have another idea how to get the wanted end result.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.