Do we have any fuctionality in Display/Threshold in which Prognosis will pick up an ID dynamically for particular WHERE condition?
For example: I want to show an BIN/RetailerID/FIID which have 100% of decline rate in current interval but I don't want to hardcoded particular ID in WHERE condition.
We have a huge no. of issuing BIN's/RetailerID's which we can't put in WHERE condition of display/threshold.
Is it possible to mention WHERE condition like DENY%="100" and BIN=*<any>
which will provide me result/alert, if any of transcating BIN have 100% denial rate in current interval time.
Hope I am clear my point here.
Is this something the avalability record can be used to solve?
i.e. somthing like detecting terminals that have not had any transactions in 7 days?
We do exactly this with Dynamic Thresholds so you don't need to hardcode the threshold values for any particular merchant. It keeps track of everyone based on Keys and filtering.
The other way to do it is with an analyst and have it do a lookup from a CSV extractor for a list to obtain a value.. this is a bit complicated but totally doable if I understand the request correctly. We've done it before for ATM monitoring for example.