This week my project required to fix the axis of multiple dot plots across several sheets in a Tableau workbook. To do this, I needed to find the possible greatest number of set of five measures which changed dynamically when applying a customer ID filter:
Set of five measures that will be displayed singularly per sheet, which require a synchronized axis for the dashboard.
Using the max() function it is possible to return the biggest record of a single or double expression. Therefore, I employed two calculated fields separetely to find the highest number of two pairs of measures at a time:
The next step was to compute these against each other, and finally against my last measure:
Finding the biggest number of dynamically changing fields is simple but involves multiple nested calculations.