Regional Revenue and Margin Dashboard - Fields Definition

Owned by Jana Volencová (Deactivated)
Dec 21, 2023
1 min read

Fields displayed on the dashboard are calculated in the following manner (using the Advanced Configuration field notation):

  • Revenue = SUM(revenue)

  • Margin = SUM(grossMargin)

  • Quantity = SUM(quantity)

  • Margin % = SUM(grossMargin) / SUM(revenue) * 100

  • Deviation WAP = (item revenue / item quantity) - (total revenue / total quantity)

  • Revenue per Customer = (item revenue) / (number of customers in a given area)

  • Margin per Customer = (item grossMargin) / (number of customers in a given area)

  • Revenue per X People = X * (item revenue) / (population in given area)

  • Margin per X People = X * (item grossMargin) / (population in given area)

 By default X is set to 1000.

The following default filters are put on various fields to ensure proper calculations:

  • Only entries with not null grossMargin are considered.

  • Only entries with not null invoicePrice are considered.

  • Only entries with not null quantity are considered.

  • Only entries with not null continent are considered (if applicable).

  • Only entries with not null country are considered (if applicable).

  • Only entries with not null region are considered (if applicable).