Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Pivot Table Grouping

reillyd
Tera Contributor

Our team's Platform Analytics admin would like to know what the allowed variable types are for the group by and additional group by field for pivot tables in the new Platform Analytics framework.  He told me that you used to be able to group by more catalog variables, but now it's only allowing select box and multiple choice.  

 

Does anyone know if more group by variable types will be supported in the future?

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @reillyd 

 

Try this way:

 

DrAtulGLNG_0-1761587148244.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi Atul,  thanks for the reply. Unfortunately toggling the Show Others doesn't reveal any more catalog variables (just the same 3 select box variables).  Interestingly, I don't have the 'Variables' column, just 'Summary of Request', which I assume doesn't matter but is a curious difference.

Hi @reillyd 

The highlight wasn’t meant to toggle; it was on apply. You can select the variable as I showed in the shared screenshot. You need to first select the item, and then based on that item, you can see the available options.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************