Share the tableau packed workbook with mock data on your requirement. People will have their unique approach for designing KPI dashboards. So they will help you by implementing the same by your requirement.
I have designed the dashboard as per your requirement.
First you have to create GAP difference
Next, Create Gap % calculation
Finally Create a calculated field for traffic light coloring
And here the sample dashboard as per your requirement. I did some simple formatting, so you can do the best formatting on your time
Hope this helps and close this question my marking this as correct. If you still facing any problem let me know!
Tableau Calculation.twbx 22.9 KB
Is it possible to do in one sheet.
If we combine all four rows in one sheet then colour formatting will be applied to first two lines as well. So current one is the best approach to get the desired result.