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?