topic Re: Count If..... in App Development

Count If.....

rbarnes0118 — Wed, 20 Mar 2019 16:17:44 GMT

Hi -

Not sure if this is the right place but I'm trying to create a Function Expression for a pie chart. I only want the function to count if it has "Y" as a response to whether or not employees took the training.

Thanks!

Re: Count If.....

bharathadde — Wed, 20 Mar 2019 16:56:07 GMT

if you need expression for percentage response 'Y'

=Count(Response='Y')/Count(Response) and make number as percentage

if you need expression for percentage response 'N'

=Count(Response='N')/Count(Response) and make number as percentage

Re: Count If.....

dwforest — Wed, 20 Mar 2019 17:11:41 GMT

two options:
Sum(If(Response='Y',1,0))
or
Count({<Response={'Y'}>}Response)
I'd probably count the "ID" field over the Response field

Re: Count If.....

rbarnes0118 — Wed, 20 Mar 2019 17:15:29 GMT

Thanks...however I have a column called "Current Product Training" and withing that column it has 'Y' for those that took the training and 'N' for those that didn't . I'm trying to compare it against the different employee titles. So dimension is "Employee Title" and Measure is "Current Product Training". I'm only looking for a percentage of "Y" from the Current Product Training Measure. Would the formula you suggested still work?