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?