Can anyone help me to understand why my total is not displayed on the top of each bar?
If I select Sum in the reference line, the total is displayed on the top of the bar chart, but if I choose Total, the value is displayed on the beginning of the chart.
Hi Gabriel,
Please see to the Sheet 3. I hope that is your expectation.
I have used the Gantt mark to replicate the Reference line. Please let me know if this helps.
The issue was due to Stacked Bar chart. PFB Scale of OTTR %
The stacked bars are placed on each other. The Reference line value was between 1-100% and hence it was showing in the middle.
if You aggregate the OTTR% , say SUM, it will cross 400, which is not right. Hence My suggestion is to use a Dual axis chart and use the below Calculated field for instructing Tableau the real size of the Stacked bars and on the Label - OTTR% is shown.
Hope this helps
sum(
{ INCLUDE [Period] :
SUM([Successful Fills (Number of)])/SUM([Total Requests (Number of)])
}
)
Sheet 3: Your expected Output
