fluentd_asana_tasks.view.lkml

view: fluentd_asana_tasks {
  sql_table_name: personal_metrics.fluentd_asana_tasks ;;
  view_label: "1 - Communications and Business"

  dimension: id {
    primary_key: yes
    type: string
    hidden: yes
    sql: ${TABLE}.id ;;
  }





  dimension: assignee_name {
    group_label: "Task Details"
    type: string
    sql: ${TABLE}.assignee_name ;;
  }

  dimension: assignee_status {
    group_label: "Task Details"

    type: string
    sql: ${TABLE}.assignee_status ;;
  }

  dimension: completed {
    group_label: "Task Details"

    type: yesno
    sql: ${TABLE}.completed ;;
  }

  dimension_group: completed_date {
    group_label: "Task Details"
    label: "Completed"

    type: time
    timeframes: [
      date
    ]
    sql: ${TABLE}.completed_at ;;
  }

  dimension_group: date_time {
    label: "Task Created"
    group_label: "Task Details"

    type: time
    timeframes: [

      date
    ]
    sql: ${TABLE}.created_at ;;
  }



  dimension: custom_task_category {
    group_label: "Task Details"

    type: string
    sql: ${TABLE}.custom_task_category ;;
  }

  dimension: custom_task_source {
    group_label: "Task Details"

    type: string
    sql: ${TABLE}.custom_task_source ;;
    drill_fields: [name,project_name]
  }

  dimension_group: due_at_date {
    group_label: "Task Details"
    label: "Due At"

    type: time
    timeframes: [
    date
    ]
    sql: ${TABLE}.due_at ;;
  }

  dimension_group: due_on_date {
    group_label: "Task Details"
    label: "Due On"

    type: time
    timeframes: [

      date
    ]
    sql: ${TABLE}.due_on ;;
  }

  dimension: hearted {
    group_label: "Task Details"

    type: yesno
    sql: ${TABLE}.hearted ;;
  }

  dimension_group: modified_date {
    group_label: "Task Details"
    label: "Modified"

    type: time
    timeframes: [

      date
    ]
    sql: ${TABLE}.modified_at ;;
  }

  dimension: name {
    group_label: "Task Details"

    label: "Task Name"
    type: string
    sql: ${TABLE}.name ;;
  }

  dimension: notes {
    group_label: "Task Details"

    type: string
    sql: ${TABLE}.notes ;;
  }





  dimension: project_name {
    group_label: "Task Details"

    type: string
    sql: ${TABLE}.project_name ;;
    drill_fields: [name]
  }

  dimension: project_owner {
    group_label: "Task Details"

    type: string
    sql: ${TABLE}.project_owner ;;
  }



  dimension: workspace_name {
    group_label: "Task Details"

    type: string
    sql: ${TABLE}.workspace_name ;;
    drill_fields: [name,project_name]
  }

  measure: count {
    group_label: "Task Metrics"

    label: "Tasks Count"
    type: count
    drill_fields: [id, project_name, assignee_name, name, workspace_name]
  }
}