Self-updating Tool-tips

Created by Steve Martin
Last updated: 19 Jun, 2021
1 min read

Here’s an interesting idea, tooltips that update as you move over data:

 

Specifically, a tooltip that increases as you roll across a selection of months, so as you hover over January, only January shall appear in the tooltip, similarly, if you hover over May, then all 5 months from January to May shall present

 

 

How:

  1. Create an integer parameter to hold the month number: Jan = 1, Feb 2 etc

  2. Create a boolean index() function scoped to the month, so Jan = 1, Feb = 2 March = 3 etc and as part of the calculation, set as Index() < parameter +1. Performing a less than calc evaluates faster than <=

  3. Now move your Index calc to the filters selecting True. This can be tested by materialising the parameter and manually updating the values

  4. On your primary sheet set the filter on the tooltip either to: fields="" for no filtering or, if you have items to filter, add these instead

  5. In the worksheet actions, set a update parameter action, set the action to hover, target your parameter and set the month of your date, ensure this is min (or max) therefore only the month number shall be captured.