The greatest measure

by Alexandra Hanna

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.

Avatar

Alexandra Hanna

Power BI venture

2 mins read

Mon 02 Nov 2015

Tableau Countdown

2 mins read

Thu 29 Oct 2015

Tweaking Tableau Server

2 mins read

Sun 06 Sep 2015

No guns allowed

1 mins read

Thu 27 Aug 2015