Hi Nick, you can try a sheet selector for your dashboard. See this: Creating a Sheet Selector for a Dashboard | Tableau Software
I specifically want everything to layout. No hiding for any sheet at all.
I can manually layout everything just fine. But the question is: if there are, for example, 30 cities in the data, manually doing this would take a long time. I am wondering if there is a simple fix I am not seeing.
Many thanks for your quick response. I am aware of putting graphs like the example you referred to.
The difficulty in my original requirement, I think, is that for each city, two or more graphs are needed (and by two or more graphs, I mean different kinds of graphs and they must be put in different coordinate systems).
Again, many thanks for your help. If there is no other way around, I guess I would have to manually create the dashboard. In the meantime, I will wait in case any body else might have a solution.
If I understand this correctly you can either do as David pointed out where bar/line for each city will be on the same pane or the alternative is to create a worksheet that contains the bar for each city and other that contains the line chart for each city- then bring it to the dashboard.
Hi P N,
First, I would like to thank you for bringing this wonderful idea to my attention.
But, in this solution, how would you place the name of the city above the two graphs to serve as a kind of title?
Oh, the nice thing about the original layout is that if a person is interested in New York, he can just look at the relevant graphs in New York section and get what he wants. But if you arrange that in the way you were proposing, graphs relating to New York would be scattering in different panes.
I am sorry for being so picky. But that is what the client wants. And I think we all know, at some point, how your manager/client would impose requirements that look nice, but impossible to implement (just because he knows little/nothing about Tableau).
1 of 1 people found this helpful
Google search for things like "panel charts". There are great examples of stuff like that out there. You can adapt the techniques to your own situation./
Here is one example:
Regarding placing the name of the city above the two side-by-side charts...
I would try to do THREE panel charts. One would be the bar chart, with a single-strip of bar charts down the dashboard. One would just be the name of the cities, again one strip down the dashboard. The third would be a strip of line charts. If you use the same filters in all three, they would correspond and line up.