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