Dashboard Platform Analytics - Variable as a group by
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago - last edited 3 weeks ago
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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