Forum Discussion

irismaessen's avatar
irismaessen
Data Pipeline
07-04-2023
Solved

How to control which Carousel value Blox displays?

I've been playing around with Blox indicators and sparklines for a while now, and I have a fantastic-looking dashboard. But... I want my widget to adjust its indicator value based on the dashboard '...
Blox
dashboards & reporting
  • irismaessen's avatar
    irismaessen
    07-06-2023

    Turns out the solution to get the aggregation to show over the entire period in the filter in combination with a sparkline is to duplicate the date column, and to put the one *not* being used as a dashboard filter in the widget as a panel value. The sparkline  should then just be the formula for the KPI of interest, and the single number value formula should have a filter in the formula for ALL([Days in SecondDate])

irismaessen's avatar
irismaessen
Data Pipeline
07-06-2023

Turns out the solution to get the aggregation to show over the entire period in the filter in combination with a sparkline is to duplicate the date column, and to put the one *not* being used as a dashboard filter in the widget as a panel value. The sparkline  should then just be the formula for the KPI of interest, and the single number value formula should have a filter in the formula for ALL([Days in SecondDate])