Dashboard Platform Analytics - Variable as a group by

ClaymoreH
Tera Contributor
 

How can I group variables from an sc_req_item in a Platform Analytics dashboard? The original documentation says it's possible, but the variables never load. I had a similar problem when trying to fetch variables in a list-type visualization; you just had to open the record and manually add variables.sys_id. But here, no matter the combination, I can't get it to work. I wanted to know if anyone knows how to solve it, either through the UI or forcing it manually.

 

3 REPLIES 3

Tanushree Maiti
Tera Patron

Hi @ClaymoreH 

 

Could you please share the screen shot where you got variable is not loading.

 

Can you refer this ServiceNow documentation: Service catalog variables in data visualizations 

 

If still variable is not loading , please clear the instance cache using cache.do and browser cache by using incognito/inPrivate mode of the browser and try once.

 

 

KB
Tera Contributor

Not really a true fix, but a potential use case that works

In the par_visualization table, there is a properties field that allows the manual intervention of variables to be added. In an example of grouping by "active", the syntax is "groupByField":"active"," and embedded in the properties field. Since this par_visualization is a table, the properties field could be exported and other visualizations could follow same syntax. Hope this helps!

Mathew Hillyard
Tera Sage

Hi @ClaymoreH 

This is the CSDM forum.

I don't believe your question is relevant to CSDM. Please post your question in a more relevant forum such as the Platform Analytics forum.

 

Thanks

Mat