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%.