Percentage KPI

[roebrich]

Hello,

I have 2 fields on my table, assignment_group and number. I want to calculate the percentage with the formula count(number) where assignment_group is null / total number.

I want it to be a KPI placed on a text object.

Thank you!

[Anonymous]

count(if(isnull(assignment_group),number))/count(number)

[ecolomer · Accepted solution]

Are you sure? Count(number)?

Count(if(IsNull(assignment_group),number))/count(TOTAL number)

[sunny_talwar]

Or create a flag in the script

LOAD number,

     assignment_group,

     If(Len(Trim(assignment_group)) = 0, 1, 0) as NullFlag

FROM ....;

and then this expression

Count({<NullFlag = {1}>} number)/Count(number)

[Anonymous]

or

count({< $-<assignment_group={"*"}  >} number)) /count(number)

--> should be faster...