Data Explorer


Hashboard supports adding calculations such as rolling averages to your Measures. You can add calculations when you are exploring any data model or saved exploration directly from the Measures dropdown.

Add a calculation to a saved exploration

  1. Go to a saved exploration or start exploring any data model.
  2. Click the Measures dropdown - the y or Measures dropdown depending on the chart type.
  3. Click Add Calculation.

If a breakout is applied, the calculation will be applied to each individual breakout series. If no breakout is applied, a second series will be added so you will see your measure side-by-side with the new calculation.

  1. A new menu will open allowing you to name your calculation and edit the calculation's options.

Calculation types

Rolling Average
Useful for helping smooth out noise in a dataset

Rolling Sum
For looking at the cumulative sum of a measure
Periods - The number of periods to include in the calculation (i.e. the size of the moving window).

Minimum periods - The minimum number of observations required for the calculation to be defined for a certain point. For example if you take a seven day moving average, but there are only five days of data before this date, then the calculation will not be defined for that day. Defaults to the same as periods

Anchor - Whether to set labels at the center of the window or at the edge. Values are Trailing, Centered, or Leading. For a timeseries chart, you will usually want this to be a Trailing average or sum.
For evaluating the absolute change over time.

Percent Change
For looking at the proportional change over time.
Constant Value
Useful for fixed goals or other fixed values for comparison
Value - The numeric value to chart as a fixed line.
More to come! Contact us if you have special requests.