- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2017 10:25 AM
Hi All
I want to create an interactive filter on our dashboard on the Assigned Too field. I create a choice filter or a reference and no luck. I get "Invalid insert" when trying to do so.
This begs the question:
1. How can I get this done?
2. How can I know which type of filter I can do for a type of field. Is there a list of what fields can be used for what? Or can you know by looking at the lineage\properties?
You can do a reference filter on Assignment Group but not Assigned too. It's confusing to understand when\where I can do these things as they are both similar type of attribute fields.
Thanks!
Solved! Go to Solution.
- Labels:
-
Dashboard
-
Performance Analytics
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2017 12:57 PM
It should be allowed for an Interactive Filter - for anything that's a choice or reference (that exists on the correct table)
Try this:
And save, then in Interactive Filter References at the bottom, create a new one for the Incident table (or whichever table you want to filter) by pointing it to the table name and the field that will hold the user:
See if that works for you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-18-2017 12:57 PM
It should be allowed for an Interactive Filter - for anything that's a choice or reference (that exists on the correct table)
Try this:
And save, then in Interactive Filter References at the bottom, create a new one for the Incident table (or whichever table you want to filter) by pointing it to the table name and the field that will hold the user:
See if that works for you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-20-2017 10:48 AM
Yes that was it. Filtering on the User (sys_user) table! Thanks very much.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-28-2020 04:36 AM
Hi All,
I want to have an interactive filter where i want assigned to me only ( Assigned to me Dynamic) .
How can i achieve the same .
Thanks in advance .
Regards
Deepak