Count function

Question & Answer
1

Hi team,
A scenario where i have to find the avg …when i tried to divide the total value count of a particular field…i got a error stating

“Mismatched aggregation. Custom aggregations can’t contain both aggregate “COUNT” and non-aggregated fields”.

kindly help me on this

2

what is your calculated field currently?

I’m assuming you just need to sum your numerator.

sum({value})/count({value})