Tag Archives: formula
Tableau: sets
If you use a parameter in a condition to create a set you can use the formula [Dimension]=[Parameter] only on the referenced dimension, if you reference a different dimension then you need a aggregate condition like MAX( IIF([Dimension]=[Parameter],1, 0) ) … Continue reading
Tableau: Distance formula
Calculate distance between 2 geographical points (great-circle distance): [VAR] * ACOS ( SIN( RADIANS([Origin-Latitude]) ) * SIN( RADIANS([Destination-Latitude]) ) + COS( RADIANS([Origin-Latitude]) ) * COS( RADIANS([Destination-Latitude]) ) * COS( RADIANS([Destination-Longitude]) – RADIANS([Origin-Longitude]) ) ) [VAR]= 3959 for miles [VAR]= 6371 … Continue reading
Do you know these tricks?
During the last couple of months I have discovered some usefull tricks, which in turn are too small for a post on its own, so I have combined them into this one. Formula for calculating the maximum scale for chart … Continue reading
Ranking without repetitive values
Here’s a question I get asked a lot: “I’m trying to use the RANK function to sort the values in Column A, but, the problem arises when I have two or more cells with the same value. Then, the RANK … Continue reading
Formula: Weeknum() in Excel 2003
In Excel 2003 the Weeknum() formula will only be activated when the Analysis toolpack is installed. Go to Options -> Addin -> select Analysis Toolpack -> OK. The formula should work now. Furthermore if you use the Dutch version of … Continue reading
