Setting maximum for dial gauge using elapsed time of dashboard

I have some dials on a dashboard. They track number of hours used within the span of the dashboard. I want the maximum of the dials to be the hours span of the time picker. Is there a way to do this?

Could you leverage variables to grab the max and feed that to the time picker?

I tried using my tablet. The max setting does not seem to take anything but a number.

aren’t those values you plotted on your gauge numbers?

This video got me what i needed. Basically you can user an expression as a transform. One if the transforms is to use a query result as a setting.

1 Like