Friday, May 14, 2021

Multiple Bars and Lines in Layers

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.


No comments:

Post a Comment