3 Replies Latest reply on Mar 11, 2013 3:46 AM by Mulukutla Sarath Chandra

    Trying to plot average price on a dual axis

    richard Hunt

      I have a very simple thing to do but cannot see how to do it in Tableau. I have a weight and value for certain items over several cycles, I want to show for each cycle, the value of goods sold by category - stacked bar chart is fine. I then want to plot the average price for each cycle on second axis. However tableau seems to want to plot average price per category per cycle. I have attached a basic tableau file which holds data and initial graph. Sheet1 is stacked graph and sheet 3 shows the average per category by cycle. I just want by cycle - that is one line.

       

      Please help

       

      Richard