Aggregated Transactions (Insights Dashboards)

Properties

  • Name – AggregatedTransactions

  • Label – Aggregated Transactions

Fields

  • Customer Id – String

  • Product Id – String

  • Month – Date

  • Quarter – Text

  • Year – Text

  • Customer Name – String

  • PFX Complete Customer Hierarchy – String

  • PFX Complete Product Hierarchy – String

  • Customer Rank – Number

  • Product Name – String

  • Product Group – String

  • Product Rank – Number

  • Revenue – Number

  • Profit – Number

  • Quantity – Number

  • Price – Number

  • Margin % – Percentage

  • Unit Margin – Number

  • Discount % – Percentage

  • Reference Price – Number

  • Reference Price Extended – Number

  • Opportunity Price – Number

  • Price Realization – Number

  • Waterfall Fields – String

  • Additional Attributes – String

  • Customer Attributes – String

  • Product Attributes – String

The available fields are determined by the fields present in your source datamart.