topic Re: Gauge Measure Expression to filter by a date and by a facility in App Development

Gauge Measure Expression to filter by a date and by a facility

lernherk — Fri, 10 May 2019 15:11:18 GMT

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!

Re: Gauge Measure Expression to filter by a date and by a facility

sunny_talwar — Fri, 10 May 2019 15:19:29 GMT

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)

Re: Gauge Measure Expression to filter by a date and by a facility

lernherk — Fri, 10 May 2019 15:36:34 GMT

The second solution worked - thank you so much!!