“Stuck on Task 3: ‘Please create a dashboard named User Events’ despite completing all steps correctly (Looker Challenge Lab

Looker Q&A Career & Social
1

Hello everyone,

I’ve completed the Get Started with Looker Challenge Lab (ARC107) multiple times over the past few days, and everything in my setup seems to be correct. However, Task 3 keeps failing with the message:

“Please create a dashboard named ‘User Events’ with specific configurations to identify the top 3 event types with the highest number of users.”

Here’s what I did, step by step:

  1. Created users_region.view.lkml

    view: users_region {
  sql_table_name: `cloud-training-demos.looker_ecomm.users` ;;
  dimension: id { primary_key: yes type: number sql: ${TABLE}.id ;; }
  dimension: state { type: string sql: ${TABLE}.state ;; }
  dimension: country { type: string sql: ${TABLE}.country ;; }
  measure: count { type: count drill_fields: [id, state, country] }
}

  2. Updated training_ecommerce.model.lkml

    • Added the users_region join to the events explore:
    explore: events {
  join: users_region {
    type: left_outer
    sql_on: ${events.user_id} = ${users_region.id} ;;
    relationship: many_to_one
  }
}

  3. Updated events.view.lkml
    Added the measure for unique user count:

    measure: distinct_users_count {
  type: count_distinct
  sql: ${users_region.id} ;;
  label: "Distinct Users Count"
}

  4. Validation Results:

    • :white_check_mark: No LookML errors found

    • :white_check_mark: 2 of 2 tests passed

    • :white_check_mark: Dashboard created successfully under Developer Student folder

  5. Dashboard Details:

    • Dashboard name: User Events

    • Tile name: Top 3 Event Types by Users

    • Explore: events

    • Dimension: Event Type

    • Measure: Distinct Users Count

    • Sorted descending by measure

    • Row limit: 3

    • Visualization: Bar chart (titles + axes configured properly)

Despite this, the progress check does not recognize the task as completed.
Is there any known issue with the verification script for this lab?
Or is there a specific naming or configuration (case-sensitive) requirement that we might be missing?

Thank you in advance for your help!

— Developer Student / Qwiklabs User

1 Like
2

Explore -Events
select Event type (Dimension)
users_region → select "Count (Measure) -(descending order)
Row limit - 3
Chart - Bar

Run → save new dashboard as - User Events (Point 3)

Check task, if not successful wait for few mins and click check task again.

1 Like
3

I have the same issue. I have done everything as described here. Also, while the view is correct the count under users_region is not appearing. Feels more like a bug

4

users_region.view.lkml

view: users_region {
  sql_table_name: cloud-training-demos.looker_ecomm.users ;;
  
  dimension: id {
    type: number
    sql: ${TABLE}.id ;;
    primary_key: yes
  }
  
  dimension: state {
    type: string
    sql: ${TABLE}.state ;;
  }
  
  dimension: country {
    type: string
    sql: ${TABLE}.country ;;
  }
  
  measure: count {
    type: count
    drill_fields: [id, state, country]
  }
}

training_ecommerce.model.lkml

connection: "bigquery_public_data_looker"

# include all the views
include: "/views/*.view"
include: "/z_tests/*.lkml"
include: "/**/*.dashboard"

datagroup: training_ecommerce_default_datagroup {
  # sql_trigger: SELECT MAX(id) FROM etl_log;;
  max_cache_age: "1 hour"
}

persist_with: training_ecommerce_default_datagroup

label: "E-Commerce Training"

explore: order_items {
  join: users {
    type: left_outer
    sql_on: ${order_items.user_id} = ${users.id} ;;
    relationship: many_to_one
  }

  join: inventory_items {
    type: left_outer
    sql_on: ${order_items.inventory_item_id} = ${inventory_items.id} ;;
    relationship: many_to_one
  }

  join: products {
    type: left_outer
    sql_on: ${inventory_items.product_id} = ${products.id} ;;
    relationship: many_to_one
  }

  join: distribution_centers {
    type: left_outer
    sql_on: ${products.distribution_center_id} = ${distribution_centers.id} ;;
    relationship: many_to_one
  }
}

explore: events {
  join: event_session_facts {
    type: left_outer
    sql_on: ${events.session_id} = ${event_session_facts.session_id} ;;
    relationship: many_to_one
  }
  join: event_session_funnel {
    type: left_outer
    sql_on: ${events.session_id} = ${event_session_funnel.session_id} ;;
    relationship: many_to_one
  }
  join: users {
    type: left_outer
    sql_on: ${events.user_id} = ${users.id} ;;
    relationship: many_to_one
  }
  join: users_region {
    type: left_outer
    sql_on: ${events.user_id} = ${users_region.id};;
    relationship: many_to_one
  }
}