Mixpanel Companies Derived Table

mp-companies.lookml

view: mp_companies {
  derived_table: {
    sql:
      SELECT
        distinct_id,
        CAST(JSON_EXTRACT_SCALAR(properties, "$.com_id") AS INT64) AS com_id
      FROM mp.event
      WHERE name = "Signed Up" ;;
  }

  dimension: distinct_id {
    type: number
    sql: ${TABLE}.distinct_id ;;
    hidden: yes
  }

  dimension: com_id {
    label: "Company ID"
    type: number
    sql: ${TABLE}.com_id ;;
  }
}