Category 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
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])
Tableau: Relative Date Filter over year change
In case you want to compare years when filtering on last x weeks and have the year comparison over the year change (week 53 and week 1), you can’t use a relative date calculated field filter as this method transforms … Continue reading
Tableau: Trend chart Previous Years in Current Year
Use the following formula to display Current and Previous Years trend lines while having a Relative Date filter: Relative Date: DATEADD(‘year’,DATEDIFF(‘year’,[Order date], today()), [Order date]) This formula will add 4 years to orders made in 2010 (if current year is … Continue reading