Calculated fields (avg) and (count)

Here I am trying to find the AVG of a commodity code, but in order to get a number I had to use the count function, but you cannot nest aggregate functions. Is there a way around this?

you could move the count() calculation to the dataset. Then it is recognized as a “normal” field in the analysis and not as a calculation.



Thanks @thomask , this is a good workaround solution. Essentially using custom sql, count() will be used as field.

Regards - San

1 Like