# Tag Archives: tableau

## 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

## Tableau: Polygon maps

In using polygon maps you need to add the polygon ID and grouping ID to details and the sequenced point ID to path in order to display your own custom group map. When you want to overlay a second axes … Continue reading

Filed under Tableau | Tagged , , , | 1 Comment

## Tableau: filter to Keep up to current day or month of year

Calculated Field for “Keep up to current day of year”: DATEPART(‘dayofyear’, [Order Date])