Chapter 5. Function Reference

Table of Contents

Overview
General Functions
Average
Comma Separated List
Comma Separated Set
Count
First
Last
Max
Median
Min
Percent
Percent100
PercentCount
PercentCount100
Standard Deviation
Sum
Variance
Year To Date
Month To Date
Additional Cube Functions
Nested Percent Variants

Overview

Many Elixir designers incorporate some form of data manipulation. For example:

  • Taking the Count of the customers in Washington using a Cube in a Composite DataSource
  • Showing a Running Sum of your accumulated sales in a Report
  • Highlighting the Percent of frozen goods sold to a chosen retailer in a Dashboard

There are a standard set of functions such as Count, Sum and Percent mentioned above that can be used throughout the Repertoire Suite.