Report Results Change Based on Group by
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago - last edited 3 weeks ago
I have a donut report on instances. This report has multiple Group by options. Depending on the group by, the total changes. If the record has no value for that group by, it should be counted in "empty" is what I assumed.
Examples
Why are some missing?
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
- Verify that Show empty values (or the equivalent option for your report type) is enabled, if available.
- If the option is not available, records with NULL values are typically excluded from the grouped results, which causes the total to be lower than the overall record count.
- Ensure the report filter itself is not excluding records where the Group by field is empty (for example, a condition such as Field is not empty).
- For Performance Analytics visualizations, confirm that the indicator source and breakdown configuration include records with empty values if that behavior is required.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
There are no filters. There is just one set of data. If the group by has some blanks, it should just show in (empty). There shouldn't be any missing records. How they are grouped shouldn't impact the count.
The (empty) is showing.