How to summarize a distinct field?

Question & Answer
, ,
1

Hi All,

What is the best practice for summing a distinct field?

Ex:
sum(distinctcount(id_evt))
This calculated field does not work.

Still, I need to calculate the percentage of the total for this field per day.

Ex:
percentageoftotal (
sum(distinctcount(id_evt)),
[date_id_evt]
)
This calculated field doesn’t work either. I tried using distinctcountover() and sumover() and it didn’t work either.

I’m waiting for help.
Thanks

2

Hi @July,

sum(distinctcount(id_evt)) doesn’t work because you need to specify what you want to group the distinctcount by.

Your calculated field should be something like sum(distinctcount(id_evt, [{group by field}])).

2 Likes