Hi Team,
We have a requirement to implement an interactive filter (Sub-tower) on a dashboard. The report is created on the Incident table; however, the standard Sub-tower field is not available on the Incident or Group table.
To handle this, we are planning to create a custom field “Sub-tower” on the Assignment Group (sys_user_group) table and manually map it with Assignment Groups, for example:
Sub Tower 1 → Assignment Group 1, 2, 3
Sub Tower 2 → Assignment Group 4, 5, 6
Sub Tower 3 → Assignment Group 7, 8, 9
Based on this setup, we want to implement an interactive filter on the dashboard using Sub-tower.
Current Issue:
When trying to use this setup (via dot-walking), the interactive filter is showing Assignment Group names instead of Sub-tower values.
Could you please confirm:
1. Is this approach feasible?
2. Why is the filter showing Assignment Groups instead of Sub-tower values?
3. What is the recommended way to create an interactive filter based on this custom Sub-tower field so that only Sub-tower values appear?
FYR: Current interactive filter
