Skip to content

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

4.5 KB
Raw Blame
title: "[[this]] per source"
transient_title: Here''s a closer look at [[this]] per source
description: Where most traffic is coming from.
applies_to: TransactionTable
metrics:
- TotalIncome:
    metric: [sum, [dimension, Income]]
- AvgIncome: [avg, [dimension, Income]]
- AvgQuantity:
    metric: [avg, [dimension, Quantity]]
- TotalOrders: [count]
- TotalUsers: [distinct, [dimension, User]]
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
- SourceMedium:
    field_type: UserTable.Source
    max_cardinality: 10
- SourceLarge:
    field_type: UserTable.Source
- Income: Income
- Quantity:
    field_type: Quantity
- User:
    field_type: User
    score: 100
- User:
    field_type: FK
    links_to: UserTable
    score: 100
- Cohort:
    field_type: UserTable.JoinTimestamp
    score: 100
- Cohort:
    field_type: UserTable.CreationTimestamp
    score: 90
- Cohort:
    field_type: UserTable.DateTime
    score: 80
- Product:
    field_type: Product
    score: 90
    max_cardinality: 10
- Product:
    field_type: ProductTable.Name
    max_cardinality: 10
- Product:
    field_type: ProductTable.Title
    max_cardinality: 10
- ProductCategory:
    field_type: ProductTable.Category
    named: category
    max_cardinality: 10
    score: 90
- Country: GenericTable.Country
- State: GenericTable.State
filters:
  - Last30Days:
      filter: ["time-interval", [dimension, Timestamp], -30, day]
  - NewUsers:
      filter: ["time-interval", [dimension, Cohort], -30, day]
groups:
- Overview:
    title: Transactions per source over time
    score: 90
- Financial:
    title: Orders and income per source
    score: 80
- UserAcquisition:
    title: Where users are coming from
    score: 70
dashboard_filters:
- SourceMedium
- SourceLarge
- Timestamp
- Country
- State
- Product
- ProductCategory
cards:
- OrdersBySourceTimeseries:
    group: Overview
    title: Transactions per source
    visualization:
      area:
        stackable.stack_type: stacked
    dimensions:
      - Timestamp
      - SourceMedium
    metrics: TotalOrders
    width: 18
    score: 100
    height: 8
- OrderBySource:
    group: Financial
    title: Total orders per source
    visualization: smart-row
    dimensions: SourceLarge
    metrics: TotalOrders
    score: 80
    height: 8
- IncomeBySource:
    group: Financial
    title: Total income per source
    visualization: smart-row
    dimensions: SourceMedium
    metrics: TotalIncome
    score: 80
    height: 8
- AvgQuantityBySource:
    group: Financial
    title: Average quantity per source
    visualization: smart-row
    dimensions: SourceMedium
    metrics: AvgQuantity
    score: 80
    height: 8
- AvgIncomeBySource:
   group: Financial
   title: Average income per source
   visualization: smart-row
   dimensions: SourceMedium
   metrics: AvgIncome
   score: 80
   height: 8
- UsersBySource:
    group: UserAcquisition
    visualization: smart-row
    title: Number of users per source
    dimensions: SourceMedium
    metrics: TotalUsers
    score: 90
    height: 8
- NewUsersBySource:
    group: UserAcquisition
    visualization: smart-row
    title: New users per source in the last 30 days
    dimensions: SourceMedium
    metrics: TotalUsers
    filters: NewUsers
    score: 90
    height: 8
- IncomeBySource:
    group: Financial
    title: Total income per source
    visualization: table
    dimensions: SourceLarge
    metrics: TotalIncome
    order_by:
      - TotalIncome: descending
    score: 80
    height: 8
- AvgQuantityBySource:
    group: Financial
    title: Average quantity per source
    visualization: table
    dimensions: SourceLarge
    metrics: AvgQuantity
    order_by:
      - AvgQuantity: descending
    score: 80
    height: 8
- AvgIncomeBySource:
   group: Financial
   title: Average income per source
   visualization: table
   dimensions: SourceLarge
   metrics: AvgIncome
   order_by:
     - AvgIncome: descending
   score: 80
   height: 8
- UsersBySource:
    group: UserAcquisition
    visualization: table
    title: Users per source
    dimensions: SourceLarge
    metrics: TotalUsers
    order_by:
      - TotalUsers: descending
    score: 90
    height: 8
- NewUsersBySource:
    group: UserAcquisition
    visualization: table
    title: New users per source in the last 30
    dimensions: SourceLarge
    metrics: TotalUsers
    filters: NewUsers
    score: 90
    height: 8
    order_by:
      - TotalUsers: descending