Average of count of users

[Anonymous]

Hi

I have a column called Emulator, i need to display a bar chart , with the average count of distinct users by emulator value

i have tried writing the expression Avg(count(distinct(user_name))) , but i get a syntax error?

what is the correct way to write this?

Thank you!

[vgutkovsky · Accepted solution]

Well, you can't have an aggregation function within an aggregation function--hence the syntax error. Also, you have too many parentheses there; user_name should not be surrounded by parantheses. I'm not sure I understand your data, but if you want to get a percentage, you would need to do a count(distinct) divided by a count(distinct total). Otherwise, you would need to used advanced aggregation, something like: avg(aggr(count(distinct user_name),Emulator))

Regards,

[#3]

Hi,

As per understanding of the problem, Please find the attached document.

Regards,

Ravi

[Anonymous]

I have tried using the expression avg(aggr(count(distinct user_name),Emulator)), but the chart display nodatatodisplay message.

[Anonymous]

Could you please let me know what is Rank here , i dont see the excel file in which you had your sample data.

[Anonymous]

Thankyou , avg(aggr(count(distinct user_name),emulator)) gave me right answer, my expression had a typo earlier.