Performance Analytics - Scripting in Formula Indicators

bhicks32
Giga Contributor

‎02-25-2019 11:35 AM

Hello,

I am experiencing issues when attempting to do IF/THEN scripting in formula indicators. Here is my current formula:

[[% of Alerts Handled Within TTR]] >= 0 ? 1 : 0

I am able to return the 1s. however I am still getting NULL values instead of 0 in the scorecard.  Essentially, I am attempting to create a new formula indicator off another existing formula indicator that inputs a 1 if there is data available and a 0 if there is NULL data. 

Any assistance here would be appreciated!

Thank you,

Ben

Labels:
0 Helpfuls
  • 2,070 Views
5 REPLIES 5

bhicks32
Giga Contributor
In response to Adam Stout

‎02-25-2019 03:39 PM

There are no NULLs when there are no breakdowns selected for % of Alerts Handled Within TTR.  The NULLs come into play when I start applying breakdowns to this formula indicator and I get NULL data for certain Assignment Groups.  When I collect the indicators associated with this formula indicator, it doesn't appear to be filling the NULL values as "0" for my breakdowns and it's only at the top level with no breakdowns applied.  Does this make sense?

0 Helpfuls