Hi
I’ve created a page with multiple pivot tables and a couple lists in it, I want to be able to search specific pivot tables/lists using a date range based on their date created, and then different pivot tables using a field i created called Date closed, again as a range, i tried using separate widget groups but it still is searching all of them, is it actually possible what I am trying or do I need to separate my searches into individual pages?
If all the page data relates to the same object and the search widget is based on that then it will filter all the page data. As such if you needed to filter only one of your selected data sets then you may want to use the search to redirect to a page that shows only that data set/pivot table/chart, etc.
You could copy paste the data widget you want to a new hidden page under the same subtab, etc., and then redirect to that, which will show the page and the single data set required.
Hopefully that would help display the data as you need it.