I would like to draw the red bars I added to the screenshot.
is it possible in Tableau?
thank you for your help
2 answers
@yaniv hugarde hi there.
You need a combination of LOD for the average, so the line axis for the Grant bar (+/-).
//Total average
SUM({SUM([Profit])})/SUM({COUNTD(DATEPART('year', [Order Date]))})
And the difference will be used as size for the Grant bar.
//Diff
(SUM([Profit])-[Total average])
After using this as dual axis here is the result.
Document attached.
Thanks,
Adrian Zinovei - Tableau Forum Ambassador
