Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamically Filtering with Gauges

My gauges show the Callout Value and I want to be able to click on the gauges and have it narrow down to those items (similar to a slicer). For example, I want to be able to click on the "Count of Ov...
  • Anonymous's avatar
    Anonymous
    6 years ago

    The answer I found to my own question is to layer a blank, transparent button over the card or gauge that you want to filter by.

    Create a bookmark that captures the different visual state of the data for each card or gauge that you want to filter by.

    Create a blank, transparent button that overlays the card or gauge. Toggle "Action" on in the formatting pane and connect it with the corresponding bookmark. 

    So the blank button is connected to the bookmark and overlays the card or gauge. When clicked on, it then connects to a bookmark. In the end it should look like clicking on a gauge or card (e.g. "Count of Overdue Blocked Stories, 13") and it would filter the report to the items included in the count of the card or gauge (e.g. the 13 items that are counted).

     

    Doing this might require an understanding of buttons and bookmarks. A great explanation to the solution is found in this video at 6:43video link  to the end.

     

    This has made my reports more dynamic and capable of seeing what items are included in the counts of numbers.

     

    Hope this makes sense and helps!