Hi there, im am playing around with Odoo 17's Dashboard Module.
create a sheet to see what i can do. I ended up with using Gauge chart with the the range and threshold within my sheet.
But i cant seem to be able to set the range and threshold of the gauge to change dynamically.
I want to ask if anyone know the work around to this, i just want the data to show in the gauge and have its thresholds and range automatically change or adapt it to the selected cells that formula.

Do anyone know if there is another way to put the cells or formular into the gauge cell's range and thresholds? If it not possible, what is the suggestion for the workaround in this approach ?