data.ml
LookML Social platform

Victory Signatures

Victory Signatures model for social platform.

source-preserved

Blocks

victory_signatures.view.lkml · 43 lines
inferred 
view: victory_signatures {
  sql_table_name: public.victory_signatures ;;

  dimension: country {
    sql: ${TABLE}.country ;;
  }

  dimension: petition_id {
    type: int
    sql: ${TABLE}.petition_id ;;
  }

  dimension: signature_id {
    type: int
    sql: ${TABLE}.signature_id ;;
  }

  dimension: staff_declared {
    type: int
    sql: ${TABLE}.staff_declared ;;
  }

  dimension: user_declared {
    type: int
    sql: ${TABLE}.user_declared ;;
  }

  dimension: user_id {
    type: int
    hidden: yes
    sql: ${TABLE}.user_id ;;
  }

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

  measure: count {
    type: count
  }
}
victory_signatures.view.lookml · 31 lines
source-preserved 
- view: victory_signatures
  sql_table_name: public.victory_signatures
  fields:
  - dimension: country
    sql: ${TABLE}.country
  - dimension: petition_id
    type: int
    sql: ${TABLE}.petition_id
  - dimension: signature_id
    type: int
    sql: ${TABLE}.signature_id
  - dimension: staff_declared
    type: int
    sql: ${TABLE}.staff_declared
  - dimension: user_declared
    type: int
    sql: ${TABLE}.user_declared
  - dimension: user_id
    type: int
    hidden: true
    sql: ${TABLE}.user_id
  - dimension_group: victory
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.victory_date
  - measure: count
    type: count

Contents

  • victory_signatures.view.lkml
  • victory_signatures.view.lookml