view: facts_prod_fact_market_share {
  sql_table_name: facts.prod.fact_market_share ;;

# UNCATEGORIZED
  dimension: orchard_monthly_marketshare_by_product_and_country {
    type: number
    sql: ${TABLE}.orchard_monthly_marketshare_by_product_and_country ;;
    hidden: yes
  }

# Date
  dimension_group: activity_month544 {
    view_label: "Date"
    label: "Activity"
    description: "Resolves for 'Activity Month 544' as provided by iTunes/Apple"
    type: time
    timeframes: [month,
      month_name,
      month_num,
      quarter,
      year,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
    sql: ${TABLE}.activity_month544 ;;
  }

# Country
  dimension: country_code {
    view_label: "Country"
    type: string
    sql: ${TABLE}.country_code ;;
  }

# Store
  dimension: storeid {
    view_label: "Store"
    label: "Store ID"
    type: number
    sql: ${TABLE}.storeid ;;
  }

  dimension: store {
    view_label: "Store"
    label: "Store Name"
    type: string
    sql: ${TABLE}.store ;;
  }

# Product
  dimension: product {
    view_label: "Product"
    label: "Product Tier"
    type: string
    sql: ${TABLE}.product ;;
  }

  dimension: is_adsup {
    view_label: "Product"
    label: "Ad-Supported"
    type: yesno
    sql: ${TABLE}.is_adsup ;;
  }

  dimension: is_bundle {
    view_label: "Product"
    label: "Bundle"
    type: yesno
    sql: ${TABLE}.is_bundle ;;
  }

  dimension: is_multiuser {
    view_label: "Product"
    label: "Multi-User"
    type: yesno
    sql: ${TABLE}.is_multiuser ;;
  }

  dimension: is_trial {
    view_label: "Product"
    label: "Trial"
    type: yesno
    sql: ${TABLE}.is_trial ;;
  }

# Market Share
  dimension: currency_conversion_to_usd_rate {
    view_label: "Market Share"
    label: "Conversion Rate to USD"
    type: number
    sql: ${TABLE}.currency_conversion_to_usd_rate ;;
   # value_format: "[>=1000000]$ #,##0.0,,\" M\"; [>=10 OR =0]$ #,##0; [>=.0000001]$ #,##0.0000;"
    }

  dimension: original_currency_code {
    view_label: "Market Share"
    type: string
    sql: ${TABLE}.original_currency_code ;;
  }

  measure: users {
    view_label: "Market Share"
    label: "Number of Accounts (Storewide)"
    description: "Previously referred to as 'Users'"
    type: sum
    sql: ${TABLE}.users ;;
    value_format: "#,###"
    }

  measure: store_streams {
    view_label: "Market Share"
    label: "Streams (Storewide)"
    type: sum
    sql: ${TABLE}.store_streams ;;
    #value_format: "[>=1000000]#,##0.0,,\" M\"; [>=10 OR =0]#,##0; [>=.0000001]#,##0.0000"
    }

  measure: orchard_streams {
    view_label: "Market Share"
    label: "Streams (Orchard)"
    type: sum
    sql: ${TABLE}.orchard_streams ;;
    #value_format: "[>=1000000]#,##0.0,,\" M\"; #,###"
    }

  measure: store_revenue_ocurr {
    view_label: "Market Share"
    label: "Revenue in Original Currency (Storewide)"
    type: sum
    sql: ${TABLE}.store_revenue_ocurr ;;
   # value_format: "[>=1000000]#,##0.0,,\" M\"; [>=10 OR =0]#,##0; [>=.0000001]#,##0.0000"
    }

  measure: store_revenue_usd {
    view_label: "Market Share"
    label: "Revenue USD (Storewide)"
    type: sum
    sql: ${TABLE}.store_revenue_usd ;;
   # value_format: "[>=1000000]$ #,##0.0,,\" M\"; [>=10 OR =0]$ #,##0; [>=.0000001]$ #,##0.0000;"
    }

  measure: orchard_gross_revenue_ocurr {
    view_label: "Market Share"
    label: "Revenue in Original Currency (Orchard)"
    type: sum
    sql: ${TABLE}.orchard_gross_revenue_ocurr ;;
   # value_format: "[>=1000000]#,##0.0,,\" M\"; [>=10 OR =0]#,##0; [>=.0000001]#,##0.0000"
    }

  measure: orchard_gross_revenue_usd {
    view_label: "Market Share"
    label: "Revenue USD (Orchard)"
    type: sum
    sql: ${TABLE}.orchard_gross_revenue_usd ;;
   # value_format: "[>=1000000]$ #,##0.0,,\" M\"; [>=10 OR =0]$ #,##0; [>=.0000001]$ #,##0.0000;"
    }
}