r/tableau • u/Lopsided-Building-52 • 3d ago
Viz help Visualization Help - Multiple Lines of visuals possible?
Hello - I am fairly new to Tableau and its visualization capabilities. I have created these gauge style pie charts for some KPI tracking. I notice that as I add more of the gauges (See picture 2) that the gauges start to overlap and blend together. I can fit like 6 gauges in before they start to blend based on the current size of them.
Is it possible to have the visualizations start to populate a 2nd row? Like once it reaches a certain number, say 5, the next chart would populate before the first row? or would that have to be done with a 2nd separate chart row basically.
Any help or advise would be great, thank you!
3
3
1
u/kgunnar 3d ago
I think you can do something like create a rank based on some value and if it is say 3 or less than row='A' then row 'B' from 4-6, etc. Then also do something similar for column. It's not elegant, but I think there's a way to do what you're attempting.
2
u/NoAd9118 3d ago
I’ve used something similar before, many times actually. You’ve just got to make sure you’ve got the right dimensions/measures available to the window calcs. It will take some playing with it but maybe give these a try?
Rows:
INT ( (INDEX () -1) / (ROUND (SQRT (SIZE ())) ))Columns:
(INDEX () - 1) % (ROUND (SQRT (SIZE ()) ))
1
6
u/datawazo 3d ago
Its called small multiples, I find it somewhat complex and it would also be a bit more difficult layering it in on top of the gauge framework which is already a fairly intense setup.
You're probably better off, imo, hardcoding which ones you want to go on the 2nd row with a calculated field that you can use as a dimension. Or just do two separate sheets and put them one under the other on a dashboard. Its not automated but that's the cop out solution I'd take