Create threshold for a transaction drops or absence

[Jerry]

How to configure a threshold when a percentage of approved transactions drops? See photo attached.

[Shoaib_Dilawar · Accepted solution]

@Jerry

w/out looking at exact record you are using in this display, considering you have the NUMAPR and NUMDEN in  a single summary record, your threshold condition (where-clause) could be

(NUMAPR/NUMTOTAL) < 0.8

However, if its not a summary record, then thresholds don't allow combines as such, so either you have to write an analyst or have to have a summary record.

[Jerry]

Great. I have uses the following for our needs: TRANCNT/TRANCNT1 < 0.85 AND TRANCNT/TRANCNT2 < 0.85

Thank you for your help

[NETS]

Hello @Shoaib_Dilawar ,

We wanted to create a threshold when there is no transaction logged. Say when TRANCNT = 0. We have tried to create threshold with the 2 seperate conditions  1) "TRANCNT = 0"  2)"TRANCNT < 1". Both didn't trigger any alert. Do you have any suggestions? 

[David_Sun]

Hi,

Try TRANCNT = EMPTY and see if it works as expected. You might test it in a display first.

Regards

David