Dynamic Threshold : No. of POS/ATM transacting trend

[G_Prasad]

Hi Team,

I have configured one display which shows me the count of ATM/POS terminals transacting in given interval time.

I used TermId field and combined it which gives total count of transacting terminals.

Now, I want its trend analysis. I am trying to achieve it by DynamicThreshold configuration but it failed to start if I mentioned TERMID field.

ADD SERIES(RECORD=DTTXNSUM, PROFILE=DayOfWeekLastWeek, FIELD=TERMID,  REMASSOC=SRCNAME, KEYS=SRCNAME)

kindly guide.

[ChristopherS]

@G_Prasad 

You have to have Dynamic Thresholds to configure it and IRDTCOL.exe has to be neabled in your Prognosis subsys. 

Assuming the above is in place, you are referring to TERMID as the field which is not part or the assocoiate name. SRCNAME is the name you define in your IRTXNCOL configuration for the gatherer. You need to refer to either TERMID or an associate name that contains it.  

ADD SERIES(RECORD=DTTXNSUM, PROFILE=DayOfWeekLastWeek, FIELD=TERMID,  REMASSOC=SRCNAME, KEYS=SRCNAME)

[G_Prasad]

Hi @ChristopherS,

Appreciated your quick response. Below is my concern on this topic.

DynamicThreshold configration is already there and we have created a dashboard which shows POS/ATM TPS trend for today/yesterdat/LastWeek. It is done by using following configuration in DYNAMICTHRESHOLDS

ADD SERIES(RECORD=DTTXNSUM, PROFILE=DayOfWeekLastWeek, FIELD=TXNRATE,  REMASSOC=SRCNAME, KEYS=SRCNAME)

ADD SERIES(RECORD=DTTXNSUM, PROFILE=TimeOfYesterday, FIELD=TXNRATE,  REMASSOC=SRCNAME, KEYS=SRCNAME)

Correct me here if I am wrong, we are getting TPS trend beacuse of TXNRATE field from DTTXNSUM and we have given SRCNAME for REMASSOC and KEYS so that I can get records from specific transaction source(Specified in BASE24 configuration).

Now If I use TERMID in REMASSOC/KEYS, then it might give me the count for specific TERMID(I suppose).

My requirement is, I want count of unique TERMID transcating in given time interval by providing SRCNAME.

I mentioned here SRCNAME because I want it ATM and POS data independently so that I can show active/transacting ATM and POS terminal counts separately.

How can we group/combine unique TERMID and get its count for today/yesterdat/LastWeek, so that display will show the trend of active POS/ATM terminal counts. 

Please find attached screenshot of configuration done to get number of current transacting count.

[ChristopherS]

@G_Prasad  

I think I see what you are trying to do.

Can you email me your DYNAMICTHRESHOLDS AND BASE24 configurations and the display you are using?

Christopher.Souser    at IR.com

[G_Prasad]

@ChristopherS ,

I have sent you all requested details.

Please let me know if you require any additional information.

Thanks in advance!

[G_Prasad]

To achieve trend of no. of transacting terminals now, yesterday and last week, I tried following practice:

• Enable key in Base24 configuration

Enable Key ( DynamicThresholdTransactionSummary, SRCNAME+TERMID)

• Add following series in DynamicThresholds configuration to collect unique terminal ids which are transacting.

ADD SERIES(RECORD=DTTXNSUM, PROFILE=TimeOfYesterday, FIELD=TRANCNT,  REMASSOC=SRCNAME+TERMID, KEYS=SRCNAME+TERMID)

ADD SERIES(RECORD=DTTXNSUM, PROFILE=DayOfWeekLastWeek, FIELD=TRANCNT,  REMASSOC=SRCNAME+TERMID, KEYS=SRCNAME+TERMID)

After this configuration, I have created one display which has following WHERE clause

REMASSOC = "SRCNAME+TERMID" AND (ACTVAL > 0 OR EXPVAL > 0)

This display is showing me multiple records with unique terminal Ids that are transacting. Please find attached screenshot for the display.

Now in this display ACTVALUE and EXPVALUE have TransactionCount(TRANCNT) values, then I grouped it over “Profile” field.

Following are my assumptions based on the configuration

• Total no. of row count(.combinedrowcount) with following condition should give me current count of transacting terminals

ACTVAL > 0 AND REMASSOC = "SRCNAME+TERMID" AND PROFILE = "TimeOfYesterday"

• Total no. of row count(.combinedrowcount) with following condition should give me yesterday count of transacting terminals 

EXPVAL > 0 AND REMASSOC = "SRCNAME+TERMID" AND PROFILE = "TimeOfYesterday"

Is my understanding is correct? If yes then how can I show it in graph, display is allowing us to show only one field .combinedrowcount. How can we proceed on this? Kindly share your thoughts on this.

Is there any other way to achieve it?

Thanks and Regards,

Tushar Devkar