topic Re: aggregation 2 Columns in App Development

aggregation 2 Columns

OnurT — Thu, 29 Sep 2022 09:48:27 GMT

Hi,

I want to make column A1 count.

A2 is singular and A3 is ="car".

count({<[A1]>}, [A3]="Car" and distinct [A2])

Thank you

sidhiq91 — Thu, 29 Sep 2022 11:01:25 GMT

@OnurT Your requirement seems to be pretty straight forward.

Dim: A2, A3

Measure: Count(Distinct A1)

OnurT — Thu, 29 Sep 2022 11:07:38 GMT

The formula I wrote did not work, I would appreciate it if you could write an example.

sidhiq91 — Thu, 29 Sep 2022 12:00:39 GMT

@OnurT Can you please provide me the sample data?