There are times when you may want to find the minimum or maximum value in a time series. Well, it can be attained by using below listed three methods in Tableau.
1- By Label Mark card.
2- By Window_Max & Window_Min functions.
3- By LODs Calculations.
In this blog, I will try to cover and explain each method by using the famous ‘Sample Superstore’ data set. Let’s start!
Getting Min and Max values by Label Mark:
This method is pretty simple and straightforward. Plot the line graph showing sales over months. Afterward, go to the Label mark and select Min/Max mark label type. Check both options “label minimum value” and “label maximum value”.
Getting Min and Max values by Window_Max & Window_Min functions:
For this method, we need to create the two calculated fields by using Window_Max and Window_Min functions.
Now drags both the measure into the axis and make the chart dual and synchronize the axis. And do formating to color the max and min value points and make labels bold.
Getting Min and Max values by LOD calculations:
For this method, we need three calculated fields. Two fields to determine the maximum and minimum total sales for a given month and one calculated field to find the point of maximum or minimum sales.
Now drag the ‘Min or Max sales’ field to rows, make the chart dual-axis, and don’t forget to synchronize the axis.
Do formatting to show max & min sales and make the labels bold.
Now you have three choices you can opt for any of the methods depending upon the analysis scenario.
