The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Performance Analytics - Script to get a count of products for a list field how to show in widget

kmolson73
Tera Expert

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. 

0 REPLIES 0