topic Re: Max Number of Combinations in App Development

Max Number of Combinations

heiko_schmidt — Fri, 03 Sep 2021 11:10:46 GMT

Hello, for each day we track error codes from our QM System.

The error codes go from 1 to 30

Maybe something like this :

Date ErrorCode

01.01.	1
01.01.	5
01.01.	18
01.01.	26
02.01.	1
02.01.	5
03.01.	26
03.01.	29
03.01.	14
04.01.	5
04.01.	18
04.01.	26
04.01.	29

Now i want to find out which error codes are most common in combination and would love to have something like frequency as measure.

Example:

as we see on 01.01. and 02.01. we habe error codes 1 and 5 in common. so for the day 02.01. the whole combination of errors already occurred on 01.01.

but when we compare 01.01. and 04.01. we see, that they have 3 out of 4 error codes in common and measure should tell me that this is the bigger hit.

Actually i do not know how to set up a measure for this one.

Any ideas?

best regards

Heiko

Re: Max Number of Combinations

Digvijay_Singh — Fri, 03 Sep 2021 12:14:07 GMT

What if you create a new field combining Date and Error Code and then count the occurrence of this field? You may use autonumber() to give a unique number for each combination..

Re: Max Number of Combinations

Saravanan_Desingh — Fri, 03 Sep 2021 19:05:37 GMT

Are you looking something like this? If an ErrorCode occurred previously then it will add to the Risk.

tab1: LOAD RowNo() As RowID,* INLINE [ Date, ErrorCode 01.01., 1 01.01., 5 01.01., 18 01.01., 26 02.01., 1 02.01., 5 03.01., 26 03.01., 29 03.01., 14 04.01., 5 04.01., 18 04.01., 26 04.01., 29 ]; tab2: LOAD RowID, ErrorCode, Date, If(Peek(ErrorCode)=ErrorCode And Not IsNull(Peek(Date)),'Y','N') As Risk Resident tab1 Order By ErrorCode, Date; Drop Table tab1;