As an Admin, you have access to the 'Data Manager' which allows you to build metrics and compound metrics.
How to create a simple metric?
A simple metric is is an aggregation applied to a single field from a single dataset
For example:
[aggregation].[dataset].[field]
[count].[orders].[order_id]The following shows you how to build one of these metrics in FleetOps.
Go to 'Data Manager' ➡ 'Datasets' and select the dataset from which you want to create a metric. In our example, we've selected the DriverDays data set.
Navigate to the 'Related Metrics' tab
Click 'Create Metric' on the top right corner of the screen
In the resulting form, enter a name for your new metric - for example, 'Count of Drivers @ Home' - and optionally add a description. The description is helpful for users of reports and dashboards when they want to understand more about this metric later.
Select the appropriate field - in our case, 'driver'
Choose the aggregation - 'count'
Add a filter if required - in this example, 'Status: Home'
Click 'Create'
When to build a compound metric?
A compound metric is a calculated metric built by applying a mathematical expression to two or more simple metrics.
Example: 'Miles / Driver / Day' is a compound metric which is calculated as follows:
Total Miles / Working Days
How to create a compound metric?
Go to 'Data Manager' ➡ 'Datasets'. Select the dataset from which you want to create a metric and navigate to the 'Related Compound Metrics' tab - in our example we've chosen the driverDays dataset.
Click 'Create Metric' on the top right corner of the screen
Enter a name - for example, 'Miles / Driver / Day' - and optionally add a description
Add each of the metrics you want to use in the calculation to the list by clicking 'Add metric' - in the example - 'Total Miles' & 'Working Days'.
Note: Currently, you can only use simple metrics in your calculation.
Each metric in the list now has a unique ID.
To create an expression copy the 'Id' of each metric using the copy icon next to the metric and paste it into the expression builder.
Most common operators are supported ( + - * / )
Some examples of compound metrics that can be built are
Deadhead %
( Empty Miles / Total Miles ) * 100Miles / Driver / Day
Total Miles / Working DaysMargin %
( Margin / Total Charge ) * 100
Set any required formatting such as precision of decimal points or a prefix / postfix (optional) such as a currency or percentage symbol.
When using the comparisons on reports and dashboards we need to know if an increase in the metric is desirable. Check the box 'Increase in the metric is desirable' to result in a green text color on your comparison values if there is an increase.
Click 'Create Metric'
