The CreatorCon Call for Content is officially open! Get started here.

Cannot get date filters working

Kass3m
Tera Expert

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.

  1. Couldn't figure out how to add an interactive date filter to it.. once I added it to a PA dashboard

  2. 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.

  3. 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.

3 REPLIES 3

Mark Manders
Mega Patron

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

RaghavSh
Kilo Patron

After adding the filter, on your dashboards widget (which contains report) setting (setting icon) did you checked “follow interactive filter”?


Raghav
MVP 2023
LinkedIn

yes, @RaghavSh follow interactive filter is turned on