Helper Functions - Positional Functions

INDEX()

FIRST()

LAST()

SIZE()

HEXBINX([Longitude] * [Scale Factor 2], [Latitude] * [Scale Factor 2]) / [Scale Factor 2]

HEXBINY([Longitude] * [Scale Factor 2], [Latitude] * [Scale Factor 2]) / [Scale Factor 2]

ACOS((SIN(RADIANS(LOOKUP(AVG([Latitude]), First()))) * SIN(RADIANS(AVG([Latitude]))) + COS(RADIANS(LOOKUP(AVG([Latitude]), First()))) * COS(RADIANS(AVG([Latitude]))) * COS(RADIANS(AVG([Longitude])) - RADIANS(LOOKUP(AVG([Longitude]), First()))) ))* [Miles/Kilometers]

{ FIXED YEAR([Order Date]), [Customer ID]: COUNTD([Order ID]) }

{ FIXED [Customer ID]: MIN(YEAR([Order Date])) }

RUNNING_SUM(COUNTD([Customer ID]))

[Running Total]/ SUM({ FIXED [Customer Cohort]: COUNTD([Customer ID])})

Place dimension into the columns shelf
Running Sum on measure in the rows shelf
Secondary Table Calc - Percent of Total along table across or adressing dimension

copy dimension into details shelf
count distinct on dimension
table calculation running totals on dimension
secondary table calculation as a percent of total
sort dims on details shelf in desc order by measure

Create a weight factor based on some variable

weight_factor = COUNT(dimension) / TOTAL(COUNT(dimension))

AVG(measure) * weight_factor

MIN({ FIXED [Country/Region], [State/Province], [Order ID]: SUM([Profit]) }) < 0


w/ State field in the Rows Shelf

Sparklines
LAST POINT: IF LAST() = 0 THEN AVG(Measure) END
LAST AVG METRIC HEADER: LOOKUP(AVG(Measure), 0)

Control Chart
Window AVG +/- Window Std Dev * N Std Dev
Use reference lines set on pane across

Bump Chart
Rank items on Specific Dimension partitioned by time period
Copy field over, set circle mark type, dual axis, synchronize
Reverse axis

Slope Chart
Set filter between start and end point
Rank on specific dimension
Reverse axis
Label line ends

IF MONTH([Order Date]) = MONTH(MAKEDATE(2017, 12, 15))

AND YEAR([Order Date]) = YEAR(MAKEDATE(2017, 12, 15))

AND DAY([Order Date]) <= DAY(MAKEDATE(2017, 12, 15))

THEN [Sales]

END

_______________________________

[TODAY] is a parameter, or can be replaced by the function TODAY()


IF DATEDIFF('year', [Order Date], [Today]) = 0 

AND DATEDIFF('month', [Order Date], [Today]) = 0 

AND [Order Date] <= [Today]

THEN [Sales]

END