Create a Metric
Last updated
Was this helpful?
Last updated
Was this helpful?
To create a metric, simply click on the + sign next to the table name in the measure panel of the exploration screen, and click on add a metric. This will open the metric creation screen.
When creating a metric you must select an operation and a column to perform the aggregation on. Whaly supports the following aggregations:
Count the number of line in your dataset. For instance counting the number of line of contacts will be the same as counting the number of contacts
Allow you to select a specific field you want to get the number of distinct value from. For instance if you apply count distinct on the first name of the contact, you will get the number of different first name your contacts have.
Allow you to sum a column. Best applied to amounts or prices. For instance you can get your revenue by summing, averaging or getting the min or max of the amount of each deal in your pipeline.
Cumulative Count
Count function counts a number of items/records that satisfy the given criteria. The cumulative count function is the sum of all the counts generated so far.
Cumulative Sum
Sum function sums a specific field of items/records that satisfy the given criteria. The cumulative sum function is the sum of all the sums generated so far.
You can also add a filter to your metric in order precisely defined which lines should be included/excluded from your metric (for example, you could set a filter to product_type equals vegetable to only count products that are vegetables)
Finally, you should give a name and a description to your metric. This is useful to keep your work clean and understandable for the viewers.
You can also add a way for your user to explore further than the chart by adding drill down on your metric, please check the following section:
The next step will ask you to select a format for your metric. You can set a custom prefix or suffit (useful for currency, weight, ...), or you can take things a step further by feature.
