- @Adam Stout , I followed the solution you provided using Performance Analytics, as it was recommended not to use a custom table.
- Step 1: I created an Indicator Source on the Legal Request table, since we have a record producer on this table.
- The facts table selected was Legal Request on indiactor source.
- This catalog item includes a List Collector variable, and we want to report those values separately.
- Step 2: I created an Indicator and selected the above-created Indicator Source.
- Step 3: I created an automated breakdown and tagged it to the indicator.
- Step 4: In the breakdown:
- I tagged a Breakdown Source that I created.
- Selected the List Collector table as the facts table in the breakdown source.
- Selected sys_id as the field in that.
- Added a condition for the specific question from which the options need to be selected.
- Step 5: I created a Breakdown Mapping on the Legal Request table and added a script (as shown in the attached screenshot).
- After completing all the setup, I ran the job:
- There are no errors during execution, it shows as collected.
- However, in the Indicator Scores, all values appear in red.
- The setup works correctly for a single-value selection, but it does not work for multiple values.
- Could you please guide me on:
- Where I might be going wrong, or
- What needs to be changed to make it work for multi-value list collectors?
- As shown in the screen shot, the commented code is for multiple value, and the uncommented code is for single value.
