project.visivo.yml

name: linear-dashboards
defaults:
  target_name: "{{ env_var('LINEAR_TARGET') }}"
includes:
  - path: dashboard/dashboard.visivo.yml
alerts: []
targets:
  - name: remote-snowflake
    type: snowflake
    database: "{{env_var('LINEAR_DATABASE')}}" 
    account: "{{env_var('LINEAR_SNOWFLAKE_ACCOUNT')}}"
    db_schema: "{{env_var('LINEAR_DB_SCHEMA')}}"
    username: "{{ env_var('LINEAR_DB_USER') }}"
    warehouse: "{{ env_var('LINEAR_WAREHOUSE') }}"
    password: "{{ env_var('LINEAR_DB_PASSWORD') }}"
    role: "{{env_var('LINEAR_ROLE')}}"
models:
  - name: issues
    sql: |
      select 
        i.*, 
        ua.display_name as assignee_name, 
        uc.display_name as creator_name
      from issue i 
      left JOIN users ua 
        on ua.id = i.assignee_id
      left JOIN users uc 
        on uc.id = i.creator_id

tables: []

selectors:
  - name: big-number-selector
    type: single
    options:
      - ref(time-to-triage-all-time)
      - ref(time-to-triage-last-ninety-days)
  - name: issue-flow-distribution-selector
    type: single
    options:
      - ref(All Time)
      - ref(Last 90 Days)

dashboards:
- name: Linear Dashboard
  rows:
  - height: compact
    items: 
      - selector: ref(big-number-selector)
      - selector: ref(issue-flow-distribution-selector)
  - height: small
    items:
      - chart: ref(Hours To Triage)
      - chart: ref(Hours Triage To Start)
      - chart: ref(Hours Start To Completed)
      - chart: ref(Issues Created Per Week)
      - chart: ref(Issues Completed Per Week)
  - name: All Time
    height: large 
    items: 
      - chart: ref(issues-distribution-daily-All Time)
      - chart: ref(sankey-chart)
  - name: Last 90 Days
    height: large 
    items: 
      - chart: ref(issues-distribution-daily-Last 90 Days)
      - chart: ref(sankey-chart)
  - height: compact
    items: 
      - selector: 
          name: issue-metrics-over-time
          type: single 
          options: 
            - ref(Issue Metrics Totals)
            - ref(Monthly Issue Metrics Broken Out By User)

  - height: medium
    name: Monthly Issue Metrics Broken Out By User
    items:
      - chart: ref(issues-created-per-user-over-time)
      - chart: ref(issues-completed-per-user-over-time)
      - chart: ref(time-to-complete-per-user-over-time)
  - height: medium
    name: Issue Metrics Totals
    items: 
      - chart: ref(issues-created-total-over-time)
      - chart: ref(issues-completed-total-over-time)
      - chart: ref(time-to-complete-total-over-time)