Skip to content

The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

939 B
Raw Blame
name: Transactions
description: Transaction (orders) data
required_attributes:
  - field: Income
  - field: CreationTimestamp
optional_attributes:
  - field: Discount
  - field: Quantity
  - field: Product
metrics:
  TotalIncome:
    aggregation: [sum, [dimension, Income]]
    name: Total income
    description: Sum of income
  AvgIncome:
    aggregation: [avg, [dimensions, Income]]
    name: Average income
  AvgQuantity:
    aggregation: [avg, [dimension, Quantity]]
    name: Average quantity
  TotalOrders:
    aggregation: [count]
    name: Total orders
    description: Total number of orders
  AvgDiscount:
    aggregation: [/, [sum, [dimension, Discount], [sum, [dimension, Income]]]]
    name: Average discount rate
    description: Discount as % of total income
segments:
  Last30Days:
    filter: [time-interval, [dimension, CreationTimestamp], -30, day]
    name: Orders in the last 30 days
breakout_dimensions:
  - Product