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

Is adding second group by (stack by) no longer available?

akshayashetty
Tera Contributor

Hi All,

 

I have few visualizations with group by and stack by options which are no longer working. When I try to create a new visualization, I can no longer see option to add second group by option? Has this been changed in Australia release?

 

Before Australia:
image (7).png
After Australia upgrade:
image (8).png
There is no Add option to specify second group by option.

2 REPLIES 2

glideFather
Tera Patron

ahoy @akshayashetty,

 

are both reports of the same type (e.g. donut-donut or pie-pie)?


✂-----Cutting-out-the---✦AI-noise✦---All-replies-written-and-vouched-for-by-GlideFather---

Tanushree Maiti
Tera Patron

Hi @akshayashetty 

 

You can  "

Configure Additional group by and Stack by choices that users can select when viewing the chart. Additional group bys can be added to any report that supports group bys (such as bar or pie) and to list reports as columns. When you configure an additional group by to a bar or horizontal bar, it is also added as an additional stack by. You can add variables and variable groups as additional group bys.

Note:
  • Available Stack by fields are limited to catalog variables, reference fields, choice lists, and boolean values. Date/time, integer, long, string, list, and text fields cannot be used as stacked fields.
  • You can see choices in the Additional group by list that do not appear in the main Group by list. The report does not support grouping or stacking by the extra fields you see. Unlike the main Group by choices, the Additional group by fields are not filtered. If you select an unsupported field, it has no effect.
  • When you select an Additional Group by field on a report and then export that report, the export shows only the initial group by set on the report, not the additional group by that you have selected."

Refer: Add an additional group by or stack by 

 

 

 

Please Accept the solution if it assisted you with your question & Mark this response as Helpful.
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti