Question

Using a BigQuery Array in drill down Look ML

  • 25 August 2021
  • 0 replies
  • 26 views

Hello,

 

I have a bigquery field with the following schema:

 

Where as endpoint is a key and it has a array with unique users for each endpoint.

 

So I am trying to do a LookML drill down with a dashboard for each endpoint I want to display the amount of unique_users and have users as a drill down. However, as I specify users as the drill down, I get no results when clicking into the graph. Do anyone know how to solve this? This is my current LookML:

 

  dimension: endpoint {
    type: string
    sql: ${TABLE}.endpoint ;;
  }

  dimension: users {
    hidden: yes
    sql: ${TABLE}.users ;;
  }

  dimension: unique_users {
    type: number
    sql: ${TABLE}.unique_users ;;
  }

  measure: countUniqueUsers {
    type: sum
    sql: ${TABLE}.unique_users ;;
    drill_fields: [users]
  }

However, when drilling into the graph and expecting to see a list of the contents of user array, Looker provides me with no results. How to fix this in LookML?


This topic has been closed for comments