Filter dashboard based on choice field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2025 05:59 PM - edited 02-17-2025 07:16 PM
Hi Team,
We have a dashboard where we have added a report (multi-pivot type), this report runs on demand task table.
We want to add a filter on the dashboard using which we can filter our reports, but the problem here is, we have a choice field which is available at Demand Table.
I am aware of interactive filters; we can use these to filter dashboard reports.... but we have a choice field here, also it is available on Demand table, I am not sure, how we can implement this.
Any suggestions would be a huge help.
- Labels:
-
Best Practices
-
Demand Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2025 06:22 PM
To set the filter field, you can dot-walk via the Parent and the respective choice field.
Please mark as helpful if the solution helps you.
Rampriya S
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2025 06:56 PM
Hi rampriya,
Thanks for your response.
I have a field 'abc' which is a custom field and its available only on demand table.
The field 'Parent' which is a reference field is coming from task table. When I click on it, it shows the fields which are present at task table, so i am unable to select my field here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2025 08:12 PM
I have tried creating a content-block (Dynamic content), The field based on which I want to filter the reports is "
Here is my script :-