All tagged Size

Showing Min & Max and Start & End in Tableau – 2 Methods

End Users are very keen to understand the time trend of the business. Chronological progression in time reveals a lot about the journey. If the time series has a lot of fluctuations, it is easier to read only the crests and troughs. But some end users just want to look at the highest value (may be the best value) and lowest value (may be the weakest value). At the same time, there will be requests to show what the start value was and what the end value is. Showing all the four values – Start, High, Low and End depicts a very good journey of data.

In this example, we will show the labels for all the 4 above mentioned data points on a Time Series on Tableau. There are different ways to achieve this. In this blog, we shall discuss 2 different methods.

Top N and Bottom N in Tableau - 4 Methods

What should a report convey? What is the end user interested in? Should we present only the best data points (strength of the data) so that the end uses are happy customers? Should we show only the weakest data points which gives room for improvement and further investigation?

How about we show the good points and bad points together? This can be done in many ways. We can show Rank charts or build Highlight tables or Heat maps or KPI shapes etc.

To keep it simple, for this blog, we are going with a simple Top N and Bottom N Bar chart. The number of values N can be static or controlled by a Parameter.