data.ml
LKML Virtual call center

Order Fact

Order Fact model for virtual call center.

inferred

Blocks

order_fact.view.lkml · 117 lines
inferred 
view: order_fact {
  sql_table_name: tblOrderFact ;;

  dimension: agent_id {
    type: int
    sql: ${TABLE}.AgentID ;;
  }

  dimension: campaign_id {
    type: int
    sql: ${TABLE}.CampaignID ;;
  }

  dimension: order_id {
    type: int
    sql: ${TABLE}.OrderID ;;
  }

  dimension: sale_club_available_count {
    type: int
    sql: ${TABLE}.SaleClubAvailableCount ;;
  }

  dimension: sale_club_count {
    type: int
    sql: ${TABLE}.SaleClubCount ;;
  }

  dimension: sale_club_revenue {
    type: number
    sql: ${TABLE}.SaleClubRevenue ;;
  }

  dimension: sale_continuity_count {
    type: int
    sql: ${TABLE}.SaleContinuityCount ;;
  }

  dimension: sale_continuity_revenue {
    type: number
    sql: ${TABLE}.SaleContinuityRevenue ;;
  }

  dimension: sale_cross_sell_count {
    type: int
    sql: ${TABLE}.SaleCrossSellCount ;;
  }

  dimension: sale_cross_sell_revenue {
    type: number
    sql: ${TABLE}.SaleCrossSellRevenue ;;
  }

  dimension: sale_decline_count {
    type: int
    sql: ${TABLE}.SaleDeclineCount ;;
  }

  dimension: sale_decline_revenue {
    type: number
    sql: ${TABLE}.SaleDeclineRevenue ;;
  }

  dimension: sale_is_manual_domain {
    sql: ${TABLE}.SaleIsManualDomain ;;
  }

  dimension: sale_is_wireless {
    sql: ${TABLE}.SaleIsWireless ;;
  }

  dimension: sale_net_revenue {
    type: number
    sql: ${TABLE}.SaleNetRevenue ;;
  }

  dimension: sale_payroll_revenue {
    type: number
    sql: ${TABLE}.SalePayrollRevenue ;;
  }

  dimension: sale_revenue {
    type: number
    sql: ${TABLE}.SaleRevenue ;;
  }

  dimension: sale_rush_count {
    type: int
    sql: ${TABLE}.SaleRushCount ;;
  }

  dimension: sale_upsell_count {
    type: int
    sql: ${TABLE}.SaleUpsellCount ;;
  }

  dimension: sale_upsell_revenue {
    type: number
    sql: ${TABLE}.SaleUpsellRevenue ;;
  }

  dimension_group: report {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.ReportDate ;;
  }

  measure: count {
    type: count
  }

  measure: total_sales {
    label: "Total Sales"
    type: sum
    sql: ${TABLE}.SalePayrollRevenue ;;
  }
}
order_fact.view.lookml · 75 lines
source-preserved 
- view: order_fact
  sql_table_name: tblOrderFact
  fields:
  - dimension: agent_id
    type: int
    sql: ${TABLE}.AgentID
  - dimension: campaign_id
    type: int
    sql: ${TABLE}.CampaignID
  - dimension: order_id
    type: int
    sql: ${TABLE}.OrderID
  - dimension: sale_club_available_count
    type: int
    sql: ${TABLE}.SaleClubAvailableCount
  - dimension: sale_club_count
    type: int
    sql: ${TABLE}.SaleClubCount
  - dimension: sale_club_revenue
    type: number
    sql: ${TABLE}.SaleClubRevenue
  - dimension: sale_continuity_count
    type: int
    sql: ${TABLE}.SaleContinuityCount
  - dimension: sale_continuity_revenue
    type: number
    sql: ${TABLE}.SaleContinuityRevenue
  - dimension: sale_cross_sell_count
    type: int
    sql: ${TABLE}.SaleCrossSellCount
  - dimension: sale_cross_sell_revenue
    type: number
    sql: ${TABLE}.SaleCrossSellRevenue
  - dimension: sale_decline_count
    type: int
    sql: ${TABLE}.SaleDeclineCount
  - dimension: sale_decline_revenue
    type: number
    sql: ${TABLE}.SaleDeclineRevenue
  - dimension: sale_is_manual_domain
    sql: ${TABLE}.SaleIsManualDomain
  - dimension: sale_is_wireless
    sql: ${TABLE}.SaleIsWireless
  - dimension: sale_net_revenue
    type: number
    sql: ${TABLE}.SaleNetRevenue
  - dimension: sale_payroll_revenue
    type: number
    sql: ${TABLE}.SalePayrollRevenue
  - dimension: sale_revenue
    type: number
    sql: ${TABLE}.SaleRevenue
  - dimension: sale_rush_count
    type: int
    sql: ${TABLE}.SaleRushCount
  - dimension: sale_upsell_count
    type: int
    sql: ${TABLE}.SaleUpsellCount
  - dimension: sale_upsell_revenue
    type: number
    sql: ${TABLE}.SaleUpsellRevenue
  - dimension_group: report
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.ReportDate
  - measure: count
    type: count
  - measure: total_sales
    type: sum
    label: Total Sales
    sql: ${TABLE}.SalePayrollRevenue

Contents

  • order_fact.view.lkml
  • order_fact.view.lookml