Cannot get date filters working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-01-2025 02:46 PM
So we created a database view between the knowledge table and AI Search events table; Created a list report from it and it works fine.
Couldn't figure out how to add an interactive date filter to it.. once I added it to a PA dashboard
Recreated the database view in Platform scope so I can use interactive filters. Trying to create a list report doesnt work so i had to do it as a visualization designer.
When I try to add a date filter by using search signal results created date, it doesnt work meaning the reports on the dashboard do not follow it.
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-02-2025 01:46 AM
My PDI is asleep, so I can't check it immediately if you can point filters to db views, but did you try that? A database view is not two tables together, but a separate view of those two tables, showing the fields you defined and you have to filter on that view, not on either of the tables itself.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-02-2025 01:59 AM - edited 10-02-2025 02:06 AM
After adding the filter, on your dashboards widget (which contains report) setting (setting icon) did you checked “follow interactive filter”?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-02-2025 04:02 AM
yes, @RaghavSh follow interactive filter is turned on
