We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Next Experience Report - Group By & Percentage Calculation

sagarravandale
Tera Contributor

3 weeks ago

Hi,

I'm trying to recreate a Classic Report in Next Experience Reports.

When I configure:

  • Group By: Priority
  • Stack By: Has breached

the chart is correct, but the percentages are calculated across all records (97.52%) instead of within each Priority (99.16%).

If I reverse the order:

  • Group By: Has breached
  • Second Group By: Priority

the percentages are correct, but the chart layout changes.

Is there any way to achieve both in a single Next Experience Report:

  • Keep Priority on the X-axis and Has breached as the stack.
  • Calculate percentages within each Priority group (like the Classic Report).
0 Helpfuls
  • 285 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron

3 weeks ago

Could you please share screenshots for both?

The best approach is to show the table data for both cases and review how the values are being calculated. This should help identify where the difference is coming from.

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG

****************************************************************************************************************
0 Helpfuls

sagarravandale
Tera Contributor
In response to Dr Atul G- LNG

3 weeks ago

Before Upgrade:

sagarravandale_0-1782449612819.png
Post Upgrade:

sagarravandale_1-1782449644661.png

Please check attached Screenshots.

 

0 Helpfuls