UI Builder - Making Data Visualizations Dynamic??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2022 12:26 PM
I'm trying to use UI Builder to work with data resources to dynamically filter data based on my filter component. This works great and I can get lists and other components to pull from the filtered data without issue. My question is, how can I use a Data visualization component (outside of the legacy Dashboard viewport component) to show the filtered data? I only get data returned when using the Table method of data source for a Data Viz component. The filters for the Data Viz components don't allow for parameterized filtering.
I can reference my results object through the Data source option seen above. But I just get a spinning indicator and I'm not sure how to setup Metric and Group By as a result.
Any help would be appreciated. Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2022 08:27 AM
Were you able to make this work? Im getting the same issue, the number is not showing up from data source. thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2022 01:59 PM
Hello Jordan,
I was able to get dynamic filtering to work following this article. Also see my attached screenshots
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.
Hope this helps!