count (val) / Total count (val)

[ShahbazovT]

Hi Experts.

There are a customer counts by utiliziation bucket, and I want to find share of  counts in each utiliziation buckets.

I use the following formula,  but I cannot get the desired result.  Please help.

Count(distinct(customer)) / count (distinct total(customer))

[QFabian]

Hi @ShahbazovT , try this please :

Case 1:

Count(distinct MUSTERI_KODU) / count (distinct total MUSTERI_KODU)

Case 2 :

Count(distinct MUSTERI_KODU) / count (distinct total <Field for totalising> MUSTERI_KODU)

[ShahbazovT]

Thank you for support.

I have two dimension fields: Date, Utilization Bucket

and measure field: count of customers.

I tried  Count(distinct customer) / count (distinct total < Utilization Bucket> customer)*100

             Count(distinct customer) / count (distinct total < Date> customer)*100

              Count(distinct(customer)) / count (distinct total(customer))

but I didn't get what I wanted

Date and Utilization fields are corrected by the expressions