|eval TotalApps=if(match('Total',"NTB"),"1","0")
|eval In-Progress=if('Total'="NTB" AND isnull('APPL_SUB-DATE'),"1","0")
|eval Submitted=if('Total'="NTB" AND isnotnull('APPL_SUB-DATE'),"1","0")
|eval My-InfoUsed=if('Total'="NTB" AND isnotnull('APPL_SUB-DATE') AND isnotnull('MY-INF0-CONCUR-FLAG'),"1","0") |stats sum(TotalApps) as "Total Apps" sum(In-Progress) as "In Progress" sum(Submitted) as "Apps Submitted" sum(My-InfoUsed) as "My InfoUsed" by Mon-Year |transpose Column_name="Category"
getting results as Category row1
Mon-Year Jan-2023
Total Apps 06
In Progress 06
Apps Submitted 0
My InfoUsed 0
But requirement is ,
Mon-Year Category Total
Jan-2023 TotalApps 06
In Progress 06
Apps Submitted 0
My InfoUsed 0
... View more