This tutorial is very helpfull, thank you Andy! One tip: In some versions of Tableau, Null is not hidden, but instead, try put "" (double quotation marks), this way: IIF(INDEX()=2,ATTR([Market]),""). Worked fine and "null" words disappear.
Hi Andy, many thanks for showing how to create grouped bar charts in such an easy manner. Can you make a video on how to add axis label at the bottom for a grouped column chart? The solution available online in Tableau community shows how to do it for column charts without groups. Once again, thanks a lot for bringing out so many high quality videos covering various concepts!
There is an easy way to by-pass 2:48 - 4:15, by simply formatting the label to vertically align. Right click on the Label -> click on "Format ..." -> under Default, set the alignment to Middle.
Hi Umar, could you please explain? I tried your approach and it didn't work. It align somewhere in the middle of second and third bar. In other words, it aligns to the middle of the pane (partition) but not on exactly the second bar. Thanks for help.
Know this is really old but was just working it up and I noticed an omission. When you created a calculated you labeled it Regions but then when you put it on the rows shelf you grabbed a different measure: it was labeled 'Regions label.' I'm not just nitpicking, I am creating the same field but I am getting two Null labels on each side of my Regions label, which is properly aligned in the middle of the grouped bars. I'm dying to know what the calculation is under Regions Label to avoid this.
Super cool trick Andy, I am just searching for this, it works perfectly, but when I swap rows and columns the Region is showing up on top of the chart. How can I display Region at the bottom (x axis)? Please clarify, thank you.
Hi, thanks a lot for posting this. Could you make this into a combination chart with 2 bars (1 for current and 1 for previous year measure values by month) and 2 lines for current and previous year for a different measure?
Hi Andy very useful tips, thanks for the great effort . give me a trick on how to conditionally format the bar chart with avg sales that's the if the sales are below avg value and above avg value
This tutorial is very helpfull, thank you Andy!
One tip: In some versions of Tableau, Null is not hidden, but instead, try put "" (double quotation marks), this way: IIF(INDEX()=2,ATTR([Market]),""). Worked fine and "null" words disappear.
You saved the day, thanks
Thanks Jorge - Great tip
Hi Andy... Very helpfull thanks a lot. do you have any trick on do this with measure value, ex- target ,actuals, forcast
Hi Andy, many thanks for showing how to create grouped bar charts in such an easy manner. Can you make a video on how to add axis label at the bottom for a grouped column chart? The solution available online in Tableau community shows how to do it for column charts without groups. Once again, thanks a lot for bringing out so many high quality videos covering various concepts!
Hi Andy, would you know why Add all subtotals might be disabled?
There is an easy way to by-pass 2:48 - 4:15, by simply formatting the label to vertically align. Right click on the Label -> click on "Format ..." -> under Default, set the alignment to Middle.
Hi Umar, could you please explain? I tried your approach and it didn't work. It align somewhere in the middle of second and third bar. In other words, it aligns to the middle of the pane (partition) but not on exactly the second bar. Thanks for help.
You are amazing, thanks for the cool tricks. Please show us more of these wonderful little tricks.
Hi Andy, if we have even no region suppose 2, we cant refer to index()=1.5, so is there any workaround there
Pick one of the others.
Know this is really old but was just working it up and I noticed an omission. When you created a calculated you labeled it Regions but then when you put it on the rows shelf you grabbed a different measure: it was labeled 'Regions label.' I'm not just nitpicking, I am creating the same field but I am getting two Null labels on each side of my Regions label, which is properly aligned in the middle of the grouped bars. I'm dying to know what the calculation is under Regions Label to avoid this.
Hi Matt. If you go to the link in the video description, you can download the workbook to see how I did it.
Super cool trick Andy,
I am just searching for this, it works perfectly, but when I swap rows and columns the Region is showing up on top of the chart. How can I display Region at the bottom (x axis)?
Please clarify, thank you.
Hi, thanks a lot for posting this. Could you make this into a combination chart with 2 bars (1 for current and 1 for previous year measure values by month) and 2 lines for current and previous year for a different measure?
Andy very helpful video..but when I try to edit axis to fix a missing total the edit axis is not working..I mean nothing happens..
Hi Andy very useful tips, thanks for the great effort . give me a trick on how to conditionally format the bar chart with avg sales that's the if the sales are below avg value and above avg value
v helpfully handy Andy. thx much.
So useful and clear! thank you! :-)