How to bind data as source in Data Visualization component in Workspace

Per5 · ‎04-25-2023

Hi,

I am trying to create a dynamic report in Service Operation Workspace where I can change the data visualization query from a dropdown.

I don't understand how to build the data source. I have tried creating a JSON object but have no idea what parameters should be included. Tried a JSON string like this but that did not work:

{
"table": "incident",
"title": "Incidents assigned to you",
"query": "active=true^assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe^ORDERBYDESC$AGGREGATE$^ORDERBYDESCsys_updated_on"
}

Here is the component setting in UI Builder:

Does someone here know how to do this?

Community Alums · ‎04-25-2023

Hi @Per5 ,

Please refer to the KB:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1156652

Basically creating a Data Resource(glideRecord Query) and then creating a page script (Dynamic filter).

Once these are completed and associated to each other, you can go to the data visualization and add an event handler.

You'll see the page script that you created. Add it and save. The results wont translate on the builder page but testing it in workspace will show the filter.