Extending explore with common calculations

I have an explore that I’d like to use solely as an extension in models. That is, there are dimensions and measures in that explore that can be reused in other explores— we use the same column name in each view. 

For example, I’d like to define `common_measures`

view: common_measures {

  measure: num_users {
    type: count_distinct
    sql:${TABLE}.user_id ;;
  }
}

Then, in a model:


include: "/views/common_measures.view.lkml"
include: "/views/test.view.lkml"

explore: common_measures {
  extension: required
}

explore: test {
  extends: [common_measures]
  }
}

I would then expect my `common_measures` calculations to display in an explore on `test`,  for example counting the num_users. I’m finding this isn’t the case and I don’t see `common_measures` anywhere. Can anyone assist?

0 0 59
0 REPLIES 0
Top Labels in this Space
Top Solution Authors