Standard metric

Standard on-demand metrics pull data and do any required calculations at the time they are needed for dashboard display. On-demand metrics are useful to display data that is calculated when the user requests it, and not ahead of time. They are also useful when the metric data is already calculated outside of Insight, and Insight is to be used to put the metrics on a dashboard for a user to interact with.

Defining an on-demand metric requires mapping the external database tables to the metric definition and specifying any custom logic and aggregation to be done.

This type of metric is useful when you want to bypass the Data mart and calculate the metric value at the moment you want to display it. It is slower and less scalable than a preprocessed metric. Create a standard on-demand metric for:

• Any data available from another data source with the metric values already computed and stored in that source.

• Metrics that need to be calculated when a button is pressed on the dashboard and cannot be calculated and stored ahead of time.