Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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)
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