I have some sample data. I have attached a workbook which gives some examples of you can use the measures pivoted as they are here.
However, I think you will have an easier time if you Unpivot your data before bringing it to Tableau, like this. If you don't have the live pivot table in excel, only the results of the pivot table as shown, then you can use PowerQuery (an add-in) to unpivot the data in excel.
Also, Tableau would let you unpivot the data. In the data tab, select the measure columns, then right-click and choose Pivot.
But in the workbook attached, I show a few options of how to use the data as it is.
You can create a map, and choose to filter by measure names. Put measure values on color and on label. The filter will show each year, and you can select the year to change the map to show that year's data. The drawback of this is that the filter is going to show all possible measures, one of which is number of records, which isn't great, not something you want to see.
You could show a different map for each of the measure names/values:
Or you could create two charts, one is a map for 2017, one is a bar chart showing the whole trend. Put these on a dashboard, and add a filter action to let the map control the trend. If you click on a state in the map, it will show the trend for that state:
I hope this gets you started. Good luck!
Fan.twbx 129.2 KB
1 of 1 people found this helpful
You need to pivot this data so that the dates come in as a dimension and the the home values come as a measure.
Thanks a lot!