Multiple sets for a measure

[deguza]

Hello all,

I have the following expression to choose only three programs for clients. It generates no error message but won't get me any results...

What is wrong with the following expression?

=avg({<[Begin Date]={">=2022-01-01"},[Program]={"='Swimming'"}>} [LengthOfStay])

After I get this working, I will add "Judo" into the program set. What should the expression be for that?

Thanks,

Deguza

[sidhiq91 · Accepted solution]

@deguza  Please use the below expression

=avg({<[Begin Date]={">=2022-01-01"},[Program]={'Swimming'}>} [LengthOfStay])

If you want to add "JUDO" then you may use the below expression.

=avg({<[Begin Date]={">=2022-01-01"},[Program]={'Swimming','Judo'}>} [LengthOfStay])

[deguza]

Thank you!

Deguza