First things first- I know everyone hates gauge charts. I get it. That being said, an executive wants to see one in a dashboard, so I need to make one.
I've been working on implementing this method that Ken Flerlage wrote about here: http://www.kenflerlage.com/2017/07/creating-nps-gauges-in-tableau.html.
I have it implemented in my dashboard, but I can't seem to figure out how to change it to a range of 0%-100% instead of -100 to 100.
Attached is the workbook and spreadsheet (both originally provided by Ken).
Can anyone advise me on how I can update this to run on a 0-100% scale? I've been toying with it for hours, have tried several other approaches, and been researching the forums and google- I haven't found a solution yet.
Thanks in advance for everyone's help- I hope this is an easy one.
Despite writing this, I'll agree about gauges. Definitely not the best option, but they can be straightforward and easy to understand as long as they are being used for a single KPI. They are terrible at comparing multiple values. That being said, here's a modified method for percentages: Percentage Gauges in Tableau - Ken Flerlage: Analytics Architecture, Strategy, & Visualization