In this post I'll go trough the process how you can create a color conditioned table based on the measure values. By this smart way of presentation you can focus the attention on the best performers and the worst ones for the dimension you want to examine.
Hi Data Heroes,
below you can see the table sheet I created with only one measure for our dataset. Here we measure the absolute value of the Sales, the Ranking based on the biggest amount of sales in the states, and the percentage of total sales per state. The creation of the view is really simple and it's in several steps. In this post I'll focus on the coloring of the table based on the absolute values of sales. Scroll down and follow the steps.
1. Create a new Sheet and add Sales in the sheet (just drag it in the sheet rectangle). Now you can see what are the options for your visuals by clicking Show me on the right.
The table options not available if you try to click on it. We need to add dimensions so we'll have at least one distribution of the numbers either in columns or in rows. Now we'll add the State field in rows by dragging it and we'll create an option for the Sales to be colored.
The setup for the table coloring is almost ready. I want to color the figures form red to green so the table will show me states with the biggest sales in green and the ones will lowest in red and between we'll have yellow ones. Another thing that I want is to see the whole cells colored not only the numbers. In the next two pictures you will see how to change the color first and after that how to change the fill of the cell in the table so it will take the color pallet which we chose.
You can see the results. It's really easy to navigate and also you can sort the data so you\ll see the dark green on the top or vice versa.
In this one minute read you learned how to use the table in more proficient way to show the full picture of your data for particular dimension and measure. Bellow you can see the Tableau result and download the dashboard and play with the sheet capabilities. In the next post we'll continue with the table functions, add some more KPI's and see how to present the results in even higher detail.
2 Comments
|