Performance Analytics - Script to get a count of products for a list field how to show in widget
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-05-2025 07:20 AM
We are working in the FSO application and have a list field for products that allows us to choose multiple products on a case record. The list is based on the sys_choice table. We are wanting to create a widget for our PA dashboard that shows a breakdown of each product with the count of how many times it's been selected on our cases. I am able to get the script to work in background script and converted that to a script include and then plan to call the script include via a PA script on the indicator source, I have the breakdown for product and the source mapping to the product field. So far when I run the jobs to pull in the data I am getting an undefined error.
Does anyone have experience or an example of something like this? I'm trying to figure out how to get the data to flow through to the widget breakdown. We need the label of the product and then the count to show in the widget.