I'm using Tableau 2018.2.2 working with a spatial dataset and some tables. When clicking on a polygon in the map window, I would like some charts to appear giving information on the polygon that was selected. I have already set up some filters to do this but it's not behaving as expected in all cases. Any advice to get back on track, or some alternative suggestions would be appreciated.
Here is my WiP dashboard as things stand:
I have my map on the left and some weather information on the bottom right.
When I select a polygon on the map, the filters begin to kick in:
Two line charts appear, giving more information on the polygon, appear along with a legend (detailing the polygon ID). The default titles for each chart from the sheet themselves are hidden, otherwise I found the title would always be displayed. I got around this by creating a new sheet and populating the Text field in the Marks pane with my title. This is behaving as intended.
However there are some instances where a polygon may be missing data for one or both charts:
In this example, the lower chart appears but not the top chart nor the legend. I believe the legend is linked to the top chart and is therefore not displaying as there is no data available. However the title for the top chart still appears which I would rather not display.
In this example, there is no data for either chart but the title for the top chart appears (bad) but the title for the bottom chart does not (good). Again there is no legend either.
Here is my filter rules:
Going back to the legend. Instead of using the legend from the top chart, I added the legend for the map sheet but it displays like this:
As you can see it displays all the polygon IDs as 'blank' boxes regardless of selection.
To style the polygons, I'm using a dual axis on the map sheet. One has the polygon IDs dropped on the colour mark while the other displays the polygons as a single colour. On selection, the unique colour displays.
My questions are:
Can anyone explain why the top title appears at all times apart from when no polygons are selected?
As an alternative solution. Is there a way to display an empty chart if there is no data available for a selected polygon? That way the empty chart and titles can display at all times and be populated with data on selection.
Is it possible to have the legend displaying the selected polygon with the correct colour, regardless of whether or not there is supplementing data, on selection?
Thanks very reading.
Fields.twbx 1.8 MB