count of
1 Topic
count with condition
Hi All, this is my data sample: Account id attackid attack date module assessName status 1 01 1/1/22 aa xx failed 1 02 2/1/22 aa yy failed 1 03 2/1/22 cc xx failed 1 04 3/1/22 aa xx completed 2 05 1/1/22 tt ss failed 2 06 2/1/22 tt ss failed 2 07 2/1/22 aa hhh failed 2 08 10/1/22 aa hhh failed 3 09 1/1/22 rr pp failed 3 10 2/1/22 aa mm failed 3 11 8/1/22 rr pp failed i'm trying to disply a table that will give me all account that runs 2 failed attakcs in row the attack must to be in a row and must to have same assessName and same module name for example account 2 had 2 failed attacks in a row with the same module = tt and the same assessName = ss acount can answer this conditions correctly more then 1 time, for example account 2 add another 2 failed attacks in a row with the same module = aa and the same assessName = hhh i want to disply on the report a table with all the attacks that answer these conditions id Last attack date module assessName 2 2/1/22 tt ss 2 10/1/22 aa hhh and then count the number of attacks that answer these conditions (count shold be 2 base on the sample data) can it be done only with maesure and not with calculated column/table ? pls help 🙂Solved1.7KViews0likes8Comments