DataPalooza 2021

ADVANCED METRIC FUNCTIONS

CONTENTS Introduction................................................................................................................................................................... 3 Getting Started .............................................................................................................................................................. 3 Create New dossier....................................................................................................................................................3 Contents Panel........................................................................................................................................................... 4 Adding Existing Metrics .............................................................................................................................................4 DERIVED METRICS..........................................................................................................................................................5 Building a Visualization..............................................................................................................................................5 Editor ..................................................................................................................................................................... 5 Filter....................................................................................................................................................................... 6 Creating a Derived Metric..........................................................................................................................................7 Percent to Total .....................................................................................................................................................7 Metric Editor - Formula .........................................................................................................................................8 LEVEL METRICS .............................................................................................................................................................. 9 Building a Visualization..............................................................................................................................................9 Editor ..................................................................................................................................................................... 9 Filter.....................................................................................................................................................................10 Creating a Metric .....................................................................................................................................................11 Median.................................................................................................................................................................11 Difference ............................................................................................................................................................12 Abs .......................................................................................................................................................................13 Thresholds ...............................................................................................................................................................13 LAG METRIC FUNCTION .........................................................................................................................................14 Building a Visualization............................................................................................................................................14 Editor ...................................................................................................................................................................14 Filter.....................................................................................................................................................................15 Creating a Metric .....................................................................................................................................................15 Lag Metric Function .............................................................................................................................................16 Difference ............................................................................................................................................................17 CASE FUNCTION...........................................................................................................................................................18 Building a Visualization............................................................................................................................................18

1 | P a g e