@ITWhisperer not certainly , here i dont know about value 4 or 5,,, it is just like any other value except 1,2,3, it should give 0 values. exact query is.. i want to see for any user how many use case got triggered in last 7 days. but i have a some critical use case list of 10 UC. suppose total are 200UC, i want to check if any incident occurred where for any user both use case combination got triggered within 7 days. (any one or more than one use case from 10 uc list ) + any use case from rest 190 UC. example user UC triggered in 7 days A UC1, UC2, UC87, UC90 UC3 i have given |eval valuex= if(UC== UC1,1, if(UC== UC2,1, if(UC== UC3,1, if...........if(uc10=="1","0") user UC triggered in 7 days valuesx A UC1, UC2, UC87, UC90 UC3 1( want it as 1,0) so here is the problem,, i am getting valuesx as 1 while it should come 1,0 both as UC triggered having combination.
... View more