topic Record count by specific dimension in App Development

Record count by specific dimension

ena1309 — Tue, 31 May 2022 08:01:25 GMT

Heyy guys,

I need measure for record count, but on a specific dimension?
Because when i do rowNo() it always returns 0.

I have dimensions: country, company code, storage location and i want for each combination - number of records.

Thank you in advance !
Ena

Re: Record count by specific dimension

marcus_sommer — Tue, 31 May 2022 09:55:54 GMT

You could use something like this: count(distinct Field) and by counting multiple dimensions: count(distinct Field1&Field2&Field3). If your other chart-expressions contain any filters you would need to use them within the count(), too.

- Marcus