So, I have two separate numbers from two separate files. One is plan and one is actuals, and I have been tasked to build a donut chart (which I know how to do in Tableau) that shows the % of plan we have achieved. Now, I can calculate that percentage easily between the two files, but how can I show that in a pie chart in Tableau?
What I need is the percentage (actuals over plan) as one slice, and the remainder of 100% (plan is the 100% value) as the other. Any ideas?