We have enhanced our Analytics application with the ability to create your own calculated measures. Now you can take the data you are already collecting and synthesize new information by applying formulas to create custom metrics. There are 4 types of calculated measures available:

  • Quantity, for handling simple numbers
  • Duration, for handling time durations like hours or weeks
  • Currency, for handling monetary transactions
  • Percentage, for handling aging calculations

You can create a new calculated measure while you are creating a new dashboard and reuse it in all the dashboard widgets. Currently, there are 2 types of aggregation formulas, which can be used with the calculated measures, SUM and AVERAGE. You can specify one of these formulas while creating a chart or by changing the chart properties from the property panel