All tagged Helper Functions

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.

Custom Territories with Aggregate Values in Tableau - 3 Methods

With Tableau 10.0 a new feature called Geographic grouping was introduced. It is an extension of the existing group feature by providing an automatic Geographic Role (Groups are manual and static buckets or segments created using existing Dimension members). Now this group acts as a parent and can be used on a Geo map without the support of the child field.

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.