
Contributor III
2022-05-31
04:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Record count by specific dimension
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
455 Views
1 Reply


MVP
2022-05-31
05:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
