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