Sales Interactive Mix Dashboard

Use the sales interactive mix dashboard to analyze sales performance by combining the grouping dimensions with two sales metrics simultaneously to create an interactive dashboard.

You can analyze graphs and tabular data with dual metrics and dual grouping of your choosing on a common monthly timeline. You can use this dashboard to perform exploratory analysis and flexibly group sales data to identify trends, concentration, and performance drivers supporting faster insights and better sales and profitability decisions.

The data in the sales interactive mix dashboard is grouped using two selectors. You can select a value in the Sales Group By 1 option to define the first level grouping and then select a value in the Sales Group By 2 option to perform a second level grouping within each group of the first level.

These are the possible values for Sales Group By 1 and Sales Group By 2 options:

  • Site
  • Warehouse
  • Customer
  • Sales Manager
  • Item
  • Product Code

The metrics in the sales interactive mix dashboard are displayed using two selectors. You can select a value in the Sales Measure 1 option to track the primary metric and then select a value in the Sales Measure 2 option to track the secondary metric. This selection creates a comparison of two related or contrasting metrics.

These are the possible values for Sales Measure 1 and Sales Measure 2 options:

  • Sales
  • Cost
  • Profit
  • Orders
  • Qty Ordered
  • Qty Shipped
  • Margin %

These are the filters in this dashboard:

  • Entity
  • Site
  • Warehouse
  • Financial Year
  • Year/Month
  • Item
  • Customer
  • Customer Order
  • Customer Order Line Status
  • Customer Order Status
  • Customer Order Type
  • Sales Person
  • Sales Manager
  • Sales Channel