- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-17-2024 02:47 PM
I have a requirement to populate a breakdown element from a Dashboard with values that I was able to only retrieve creating a database view.
The breakdown element is on Assigned To field from Interaction table.
The database view is a join of interaction, sys_user_has_skill, cmn_skill and sys_user tables.
Because I want to show on the breakdown element only the users populated on Assigned To field on Interaction table that have specific skills.
But now, I'm not being able to pull those values on the breakdown element.
I tested the following script on the background script and it is returning the exactly correct users I want to see on the breakdown element:
// used gs.info(gr.user_name); to test on the background script
I tried creating a breakdown mapping where the facts table is the sys_user and the script contains the above script.
Also tried creating a bucket group but it didn't work.
Anyone can help me with this?
Thank you very much
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2024 02:21 PM
In case anyone else faces this issue too, I made it work by creating a script include and calling it into the Breakdown source filter.
The Script Include must be Client callable
Here's the code:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2024 02:21 PM
In case anyone else faces this issue too, I made it work by creating a script include and calling it into the Breakdown source filter.
The Script Include must be Client callable
Here's the code: