Write a calculated dimension

[#1]

I would like to have the next as a calculated dimension:

=class(count(DISTINCT emptyings_id),20)

and the one below as expression:

count(DISTINCT emptyings_id

The idea is to make a graph where the % count of emptyins_id is shown in a certain class.

The calculated dimension however gives a calcutation error.

How do I write this correctly?

Kind regards,

Katleen

[whiteline]

Hi.

You should use aggr() function to build calculated dimension.

[#3]

Can you give me a little hint how to make this into an aggregated expression?

[#4]

Hi,

Can You upload  sample data ?

[SunilChauhan · Accepted solution]

as you are using aggregation function (count) thats y its showing error. you could use with aggr

like below

class(aggr(count(DISTINCT emptyings_id),emptyings_id),20)