This article review the purchasing and receiving dashboard master. 


Upon opening the Purchasing & Receiving Dashboard Master, users may be prompted to select a date parameter. The default setting is set to the date that is 3 months back from the current date.  Once loaded, the dashboard master will feature the data within the date window. 


This dashboard cannot be edited. However, should any changes need to be made, users can duplicate this dashboard master and edit the copy.



The Purchasing & Receiving Dashboard Master uses the purchasing & receiving dataset to create the following visualizations:



Pricing Analysis





FieldDescription
Attribute SelectorThis selector allows users to select the attribute that is featured in the Pricing Analysis grid. When set to Item Name, each individual item will be listed. When set to an Item Category 1, 2, or 3, each category will be listed.
Attribute
Attribute elements from the selected attribute will be listed here. For Item Name, this will be the list of individual items. For Item Category 1, 2, & 3, this will be the list of item categories. 
Ordered AmountDollar amount of the item or items within the item category ordered. This is based on the ordered quantity.
Ordered QYNumber of the item or items within the item category ordered.
Received AmountDollar amount of the item or items within the item category received. This is based on the received quantity. 
Received QTYNumber of the item or items within the item category received.



This visualization and selector were created using the following attributes and metrics:

  • Attribute
    • Item Name
    • Item Category 1
    • Item Category 2
    • Item Category 3
  • Metrics
    • Ordered Amount
    • Ordered QTY
    • Received Amount
    • Received QTY



Ordered & Received by Vendor Graph





FieldDescription
Ordered/Received AmountThe vertical axis shows the total dollar amount ordered and received from each vendor. 
Vendor NameThe horizontal axis shows the vendor names. 
Bar 1 - Ordered AmountBar 1 represents the total dollar amount ordered from the specified vendor.

Hovering over the bar will show the vendor name and the exact ordered amount.
Bar 2 - Received AmountBar 2 represents the total dollar amount received from the specified vendor.

Hovering over the bar will show the vendor name and the exact received amount.



This visualization was created using the following attributes and metrics:

  • Attributes
    • Vendor Name 
  • Metrics
    • Ordered Amount
    • Received Amount

Ordered & Received by Vendor Grid





FieldDescription
Vendor NameThe list of vendor names.
Ordered AmountThe total dollar amount of items ordered from the vendor.
Received AmountThe dollar amount of items received from the vendor. 
Spend Variance TrendThe Spend Variance Trend within the visualization was done by creating a Sparkline Microchart using the Date attribute and Ordered Amount metric.



This visualization was created using the following attributes and metrics:

  • Attributes
    • Vendor Name
  • Metrics
    • Ordered Amount
    • Received Amount