I need to create a clock showing the reduction of costs in the previous year, and my boss wants the scale is inverted, ie, the first segment starting with 100%, then 0% -10% and most usually do the opposite .
Since it's impossible to set the gauge min to greater than the max, you will need to do some manipulation in your expression to get this to work. To position the needle in the correct place, you should be able to simply do 1 - your_expression. To get the proper values to show on the gauge is a bit trickier. You might have to turn off the automatic scaling and instead insert Text in Chart (using CTRL+SHIFT to manipulate it into the right positions on the gauge.