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