Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a gauge-based KPI sheet in my project. My problem is I need the gauges to all "face the same direction" i.e. green always on the right side of the gauge, but for some KPIs, a higher number is better, and for some a lower number is better.
This is one of the gauges. It is for a scrap %. I played around with subtracting the value and reference lines from 1 to reverse the metric, so higher is better.
Is there a way in the formatting to switch it back to 5.43 in the center of the gauge?
Is there an extension where you can have exactly three sections designated like in the vanilla chart that has the functionality I'm looking for? The clients specifically want them facing the same way and with three sections.
Thanks,
Elizabeth
Something like this?
If so then you could test and
Having changed the format pattern the data is negative, but displayed as positive. Not sure if that causes you any other issues.
Regards,
Patrik.
You can change where the red, yellow and green appear on the gauge.
Yes, like in the screenshot I did that with this metric on the right. Original gauge is on the left, swapped is on the right.
I switched the green and red areas, and subtracted all my values from 1 to effectively change scrap % to good pieces %. This is confusing for the users where the 94.57% appears -- they are used to seeing a scrap value that is around 5%.
I want to know if with number formatting or by some other means, I can have:
I can achieve the first item by switching the percentage to be good pieces % (94.57%), but that number is not clear to the users.
Something like this?
If so then you could test and
Having changed the format pattern the data is negative, but displayed as positive. Not sure if that causes you any other issues.
Regards,
Patrik.