mantagoal.view.lkml

view: mantagoal {
  sql_table_name: capacity.mantagoal ;;


  dimension: compound_primary_key {
    primary_key: yes
    hidden: yes
    sql: ${TABLE}.date  || ${TABLE}.region;;
  }

  dimension_group: date {
    description: "Timestamp for the goal normalized PiB to be available"
    type: time
    timeframes: [
      raw,
      date,
      week,
      month,
      quarter,
      year
    ]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.date ;;
  }

  dimension: goal {
    description: "PiB for the region's goal"
    type: number
    sql: ${TABLE}.goal ;;
  }

  dimension: region {
    description: "The name of the region"
    type: string
    sql: ${TABLE}.region ;;
  }

  measure: count {
    description: "Number of distinct objects returned in query"
    type: count
    drill_fields: []
  }
  measure: goalsum {
    description: "Sum of Normalized PiB"
    type: sum
    sql: ${goal} ;;
  }
}