Skip to content

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

5.3 KB
Raw Blame
title: A look at [[this]]
transient_title: It looks like [[this]] has transactions, so here''s a look at them
description: Some metrics we found about transactions.
metrics:
- AvgDiscount:
    metric: [/, [sum, [dimension, Discount]], [sum, [dimension, Income]]]
    name: Average discount %
- TotalIncome:
    metric: [sum, [dimension, Income]]
    name: Total income
- AvgIncome:
    metric: [avg, [dimension, Income]]
    name: Average income per transaction
- AvgQuantity:
    metric: [avg, [dimension, Quantity]]
    name: Average quantity
- TotalOrders:
    metric: [count]
    name: Number of orders
dimensions:
- Timestamp:
    field_type: CreationTimestamp
    score: 100
- Timestamp:
    field_type: CreationDate
    score: 100
- Timestamp:
    field_type: DateTime
    score: 90
- Timestamp:
    field_type: Date
    score: 90
- State:
    field_type: GenericTable.State
- Country: GenericTable.Country
- Income: Income
- Discount: Discount
- Quantity:
    field_type: Quantity
- SourceSmall:
    field_type: GenericTable.Source
    max_cardinality: 5
- SourceMedium:
    field_type: GenericTable.Source
    score: 90
- Cohort:
    field_type: UserTable.JoinTimestamp
    score: 100
- Cohort:
    field_type: UserTable.CreationTimestamp
    score: 90
- Cohort:
    field_type: UserTable.DateTime
    score: 80
- ProductMedium:
    field_type: Product
    score: 90
    max_cardinality: 10
- ProductMedium:
    field_type: ProductTable.Name
    max_cardinality: 10
- ProductMedium:
    field_type: ProductTable.Title
- ProductMedium:
    field_type: ProductTable.Name
- ProductMedium:
    field_type: ProductTable.Title
- ProductCategoryMedium:
    field_type: ProductTable.Category
    named: category
    score: 90
- Long: GenericTable.Longitude
- Lat: GenericTable.Latitude
filters:
  - Last30Days:
      filter: ["time-interval", [dimension, Timestamp], -30, day]
      score: 80
groups:
  - Overview:
      title: Overview
      score: 90
  - Geographical:
      title: Where these transactions happened
      score: 70
  - General:
      title: How these transactions are distributed
      score: 80
dashboard_filters:
  - Timestamp
  - SourceSmall
  - SourceMedium
  - Country
  - State
  - ProductMedium
  - ProductCategoryMedium
cards:
# Overview
  - Rowcount:
      title: Total transactions
      visualization: scalar
      metrics: TotalOrders
      score: 100
      group: Overview
      width: 5
      height: 3
  - RowcountLast30Days:
      title: Transactions in the last 30 days
      visualization: scalar
      metrics: TotalOrders
      score: 100
      filters: Last30Days
      group: Overview
      width: 5
      height: 3
  - IncomeGrowth:
      visualization: smartscalar
      title: Income growth
      dimensions: Timestamp
      metrics: TotalIncome
      width: 5
      height: 3
      group: Overview
  - IncomeByMonth:
      visualization: line
      title: Sales per month
      description: Total income per month
      dimensions: Timestamp
      metrics:
        - TotalIncome
        - TotalOrders
      width: 18
      height: 6
      group: Overview
# General
  - AverageQuantityByMonth:
      visualization: line
      title: Average quantity per month
      description: Average item quantity per month
      dimensions: Timestamp
      metrics: AvgQuantity
      group: General
  - AverageIncomeByMonth:
      visualization: line
      title: Average transaction income per month
      dimensions: Timestamp
      metrics: AvgIncome
      group: General
  - AverageDiscountByMonth:
      visualization: line
      title: Average discount per month
      dimensions: Timestamp
      metrics: AvgDiscount
      score: 70
      group: General
  - OrdersByProduct:
      title: Sales per product
      visualization: smart-row
      dimensions:
        - ProductMedium
      metrics: TotalOrders
      score: 90
      height: 8
      group: General
  - OrdersByProductCategory:
      title: Sales for each product category
      visualization: smart-row
      dimensions:
        - ProductCategoryMedium
      metrics: TotalOrders
      score: 90
      height: 8
      group: General
  - OrdersBySource:
      title: Sales per source
      visualization:
        area:
          stackable.stack_type: stacked
      dimensions:
        - Timestamp
        - SourceSmall
      metrics: TotalOrders
      width: 12
      height: 8
      score: 100
      group: General
  - OrdersBySource:
      title: Sales per source
      visualization: smart-row
      dimensions: SourceMedium
      metrics: TotalOrders
      score: 90
      height: 8
      group: General
# Geographical
  - CountByCountry:
      title: Sales per country
      metrics: TotalOrders
      dimensions: Country
      score: 90
      visualization:
        map:
          map.type: region
          map.region: world_countries
      group: Geographical
  - CountByState:
      title: Sales per state
      metrics: TotalOrders
      dimensions: State
      score: 90
      height: 10
      width: 7
      visualization:
        map:
          map.type: region
          map.region: us_states
      group: Geographical
  - CountByCoords:
      title: Sales by coordinates
      metrics: TotalOrders
      dimensions:
        - Long:
            aggregation: default
        - Lat:
            aggregation: default
      visualization: map
      score: 80
      height: 10
      width: 11
      group: Geographical