Custom Measure based on logical OR of 4 dimensions in table

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?

0 2 433
2 REPLIES 2
Top Labels in this Space