topic Re: count (val) / Total count (val) in App Development

count (val) / Total count (val)

ShahbazovT — Fri, 02 Apr 2021 08:43:18 GMT

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 — Wed, 18 Nov 2020 14:31:55 GMT

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 — Wed, 18 Nov 2020 14:53:59 GMT

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