GSP361 challenge lab

[archanasuji]

Hi,

Did anyone completed first task in GSP361 challenge lab. total_gross_margin field is throwing error saying include the correct specification.

Please help if you got the solution

Regards,

Archana

[blackraven]

Here are my codes:

  # TODO: Add dimensions and measures here
  dimension: is_search_source {
    type: yesno
    sql: ${users.traffic_source} = "Search" ;;
  }

  measure: sales_from_complete_search_users {
    type: sum
    sql: ${order_items.sale_price} ;;
    filters: [users.traffic_source: "Search", order_items.status: "Complete"]
    value_format_name: usd_0
  }

  measure: total_gross_margin {
    type: sum
    sql: ${order_items.sale_price} - ${products.cost} ;;
    value_format_name: usd_0
  }

  dimension: return_days {
    type: number
    sql: DATE_DIFF(${order_items.delivered_date}, ${order_items.returned_date}, DAY) ;;
  }

The subtasks are successful thus far.

However, I’m not able to cross the next task: Join the view to an Explore

My codes:

  join: order_items_challenge {
    type: left_outer
    sql_on: ${order_items.order_id} = ${order_items_challenge.order_item_id} ;;
    relationship: many_to_one
  }

The error message is: Please create a view to join order_items explore. Which means the new view created is not valid?

Would you share your solution here please? (so that we can explore further steps)

[blackraven]

I have managed to complete this lab, but I think there's a bug in the last 5 minutes

See my solution: https://youtu.be/DP_oXW8MGcY

Build LookML Objects in Looker: Challenge Lab GSP361 solution