Calculated fields (avg) and (count)

Question & Answer
,
1

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?

image
image846Ă—101 3.51 KB

1 Like
2

Hi,
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.

Thomas

5 Likes
3

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

Regards - San

1 Like