1 Reply Latest reply on Feb 1, 2013 3:04 PM by Shawn Wallwork

    Want to understand how I would Sum 2 averages without the sum being an average.

    Paul D'Angelo

      I have % data coming into my database at the daily level. I am summing to the monthly level and therefore need to take an average ov the data.

       

      In this instance I have 2 directional categorys +/-, they exist seperatley. I want to group them together so I can display a stacked bar above and below the axis with a line running through the middle that represents the sum:

       

      + = 10%

      -  = -5%

       

      Ideally displays as 5% however since they are averages tableau turns it into 2.5%.

       

      Thanks

       

      Paul