I am working with a table which has 4 related dimensions (let’s say A,B,C,D) any of which may be not null. Now I understand how to make a custom measure based on one of these. e.g.
measure: foo_A {
type: count
filters: [A: “foo”]
}
and I see that you can count based on multiple dimensions:
measure: foo_ABCD {
type: count
filters: [A: “foo”, B: “foo”, C: “foo”, 😧 “foo”]
}
but this would count only records in which A, B, C and D are all set to ‘foo’. What I would like is a foo_count that would count the records in which A,B,C or D are set to ‘foo’. Any suggestions on how to do that in LookML?