Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

Report Results Change Based on Group by

Robert Campbell
Tera Guru

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

Screenshot From 2026-07-08 06-56-51.pngScreenshot From 2026-07-08 06-56-31.pngScreenshot From 2026-07-08 06-56-12.png

 

Why are some missing?

2 REPLIES 2

prajaktakha
Tera Contributor

 

  • 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.
  •  

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. 

 

RobertCampbell_2-1784825071519.png

 

 

The (empty) is showing.

RobertCampbell_0-1784824715642.png

 

RobertCampbell_1-1784824946983.png