To have multiple bars and lines with categories in the same worksheet has been hard with Tableau. This request has come up from time to time. Dual axis won't cut it. With the new layering technology, it becomes possible. Inspired by Tableau Zen Master Adam McCann's exemplary Zoomable dashboard, I created this little quick-and-dirty demo dashboard laying lines and bars over each other.

Here are the two geo type fields that are created:
One trick is to create a hardcoded index for categories, because an aggregated Index() won't work in the formula.
A parameter Spacing is used to fine-tune the space between the bars.

When designing map layer based charts,  we need to turn off the background map.
The workbook can be download here.


0

Add a comment

[Forward: I asked ChatGPT o1-mini who then wrote this. Hope it helps. All the credit and the blame go to ChatGPT.

I went over the plan and it looked decent. Whether it can be done in 30 days or not, it depends on the person and the time he spends on it.
Just came back from Tableau Conference 2022 at Las Vegas. What an exciting event! The most exciting thing is reuniting with old friends and meeting with the datafam people known online for years.

Attended first time the Tableau Visionary summit.
A little enhancement in the formula editor can make a big difference for whose who create formula all the time in Tableau. Here are my wishes for a future editor. 

Highlighting Syntax Words

Currently a formula in Tableau can look plain and a bit uninspiring.
Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.