2 Replies Latest reply on Nov 4, 2016 1:39 PM by ann.stolzman

    Create pie chart showing % of another number

    ann.stolzman

      Hi all,

       

      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?

       

      Thanks and Happy Friday!

      -A-