Hey! You need Admin permissions to do this.
Simply put, a metric is a measurement. In SQL and database structures, a metric is like a stored query over a variable period of time.
In Magento BI, you can use metrics to create charts. For example, the metric revenue is the total amount of orders. The metric average customer revenue per order is what the average customer spends per order.
When used in reports, metrics can be analyzed over a specified time period and filtered or segmented by different categories. Consider analyzing average customer revenue grouped by gender - in this case, average customer revenue per order is the metric and gender is the grouping.
Use the links on the side to jump around the article. Let's get started!
The Filter section allows you to create a new filter or apply a saved filter set to your metric.
For our average order revenue metric, we wouldn’t want to include any test orders that might have been done while setting up our store - this would give us an inaccurate result. We can apply a filter set to remove those orders from the data set. After the filter is created, it will apply to all charts built using this metric.
The Filter Logic section is where you can further define how a metric should behave.
The Dimensions section shows all available data dimensions for filtering or grouping; by default, all available data columns are listed as dimensions. Continuing our example, if we wanted to segment our revenue by referral source, we could do that here.
In addition to listing all available data columns as dimensions, Magento BI will also take a guess at which columns are groupable. To segment or group data on reports, columns must be marked as groupable.
In addition to defining how your metric behaves, you can also set permission levels in the User Rights section. While Admin users have access to all metrics, you have to indicate the users who can use this metric by checking the box next to the appropriate group.
If you’re editing an existing metric, you can view a list of charts (and who owns them) that use this metric in the Dependent Charts section.
That’s it! Changes are saved automatically, so your metric is now good to go.