6 Replies Latest reply on Oct 14, 2019 2:25 PM by Peter Fakan

    Keyword search based on filter value

    Vianny Lugo-Aracena

      Hi all!

       

      I wonder whether it is possible to do keyword searches based on a filter value. I am filtering worksheets based on the value of a field called Movement, and it is successfully calling the right image and chart to the dashboard once the value is changed:

      Screen Shot 2019-10-13 at 3.41.14 PM.png

       

      Here are the values of the movement field:

      Screen Shot 2019-10-13 at 3.41.53 PM.png

       

      What I'm hoping to do is that once the filter option has been changed, that the "search" caption automatically does a search through the captions for any caption where the string "squat" (or whatever the value is) appears, without having to manually type it. I've tried using parameters and trying to change filter conditions by formula but I keep getting an error about using aggregate functions. Is it possible to search through text based on filter values? Or are there any workarounds?

       

      I am attaching the workbook below!