@gcusello I tried the suggestions but rename field and the query didn't work. Sorry that I didn't display my eval experssions earlier. Here is my basic query which results into two rows and 6 columns. index=indexA OR index=indexB | eval indexA_CategoryA = if( (IN(status_code, "m", "p") OR like(status_code, "n%")) , 1, 0) | eval indexA_CategoryB = if( like(status_code, "s%") , 1, 0) | eval indexA_CategoryC = if( (like(status_code, "^%") OR like(status_code, "h%")) , 1, 0) | eval indexB_CategoryA = if( (IN(category_code1, "m", "p") OR like(category_code1, "n%")) AND isnull(TO_DT), 1, 0) | eval indexB_CategoryB = if( like(category_code1, "s%") AND isnull(TO_DT), 1, 0) | eval indexB_CategoryC = if( (like(category_code1, "^%") OR like(category_code1, "h%")) AND isnull(TO_DT), 1, 0) | stats sum(indexA_CategoryA) as indexA_CategoryA, sum(indexA_CategoryB) as indexA_CategoryB, sum(indexA_CategoryC) as indexA_CategoryC, sum(indexB_CategoryA) as indexB_CategoryA, sum(indexB_CategoryB) as indexB_CategoryB, sum(indexB_CategoryC) as indexB_CategoryC by index index indexA_CategoryA indexA_CategoryB indexA_CategoryC indexB_CategoryA indexB_CategoryB indexB_CategoryC IndexA 45 201 75 0 0 0 IndexB 0 0 0 45 189 76
... View more