Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm trying to come up with an expression for my measure that filters a date field by what is after today and also by a certain facility. The first part of my expression is working:
Count({<ExpirationDate={">$(=Date(today(),'YYYY-MM-DD'))"}>}UserId)/Count(UserId)
This expression gives me the correct percentage of total users that have an expiration date of after today. I also need to filter this by FacilityID = 1024.
Any help is appreciated!
May be this
Count({<ExpirationDate={">$(=Date(today(),'YYYY-MM-DD'))"}, FacilityID = {1024}>} UserId)/Count(UserId)
or this
Count({<ExpirationDate={">$(=Date(today(),'YYYY-MM-DD'))"}, FacilityID = {1024}>} UserId)/Count({<FacilityID = {1024}>} UserId)
May be this
Count({<ExpirationDate={">$(=Date(today(),'YYYY-MM-DD'))"}, FacilityID = {1024}>} UserId)/Count(UserId)
or this
Count({<ExpirationDate={">$(=Date(today(),'YYYY-MM-DD'))"}, FacilityID = {1024}>} UserId)/Count({<FacilityID = {1024}>} UserId)
The second solution worked - thank you so much!!