How to get the count/data of costumer with unique / distinct request(Expression)?

userpd_2021 — Fri, 15 Nov 2024 21:31:23 GMT

Hi All,

My requirement there is to get the count of costumers who have an unique or distinct request which is not associated with other Costumers.

Ex:Below is the list of costumers and their request with the location . I want to pick out customers with unique request att the same location.

Result: As Customer 3 , 4 and 8 have unique request I want to only show this unique combination. How can this be performed?

Re: How to get the count/data of costumer with unique / distinct request(Expression)?

maxgro — Thu, 03 Aug 2023 15:53:03 GMT

maybe a table with 2 dimensions,

Customers, Request

and one measure

IF(count(TOTAL <Request> Request)=1, Location)