How to use Mathematical Operators?

Learn how to use Mathematical Operators.

Updated over a week ago

Mathematical Operators:

This operator performs purely mathematical functions on the metrics selected by you.

You can perform all basic operations on metrics like:

  • Average

  • Maximum Value

  • Minimum value

Average:

This Operator shows the average value of the selected metric. You can use this operator to either find the average value of a metric.

Maximum Value:

This operator shows the maximum value of a selected metric.

For example, ”Maximum Sales in previous year” will fetch the maximum sales data made in the previous year.

Some examples to help you understand this are as follows:

  • Maximum payment in January

  • Maximum invoice issued by country

  • Maximum spend by vendor

This combination of Operators, Metrics, and Dimensions shows you the maximum sales in the last year

Minimum Value:

This operator shows the minimum value of a selected metric.

For example, ”Minimum Sales in previous year” will fetch minimum sales value made in the previous year. Example shown below:

Some more examples to understand how to use this keyword:

  • Minimum contracts updated in last quarter

  • Minimum spend by country

Did this answer your question?