Next Experience Report - Group By & Percentage Calculation

sagarravandale
Tera Contributor

7 hours 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
  • 134 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron

5 hours 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
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

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