Hi,
We tried the below query and it returned null results.
index="roche_aid3" |stats count("Appl ID"!=blank) as "Appl ID",count(eval("Appl Id"=blank)) as "Appl ID_blank",count(eval("Appl Name"!=blank)) as "Appl Name",count(eval("Appl Name"!=blank)) as "Appl Name_blank",count(eval("Appl Description"!=blank)) as "Appl Description",count(eval("Appl Description"=blank)) as "Appl Description_blank",count(eval("Appl Size"!=blank)) as "Appl Size",count(eval("Appl Size"=blank)) as "Appl Size_blank",count(eval("Service Level"!=blank)) as "Service Level",count(eval("Service Level"=blank)) as "Service Level_blank",count(eval("Lifecycle Stage"!=blank)) as "Lifecycle Stage",count(eval("Lifecycle Stage"=blank)) as "Lifecycle Stage_blank",count(eval("Geographic Scope"!=blank)) as "Geographic Scope",count(eval("Geographic Scope"=blank)) as "Geographic Scope_blank",count(eval("Line Of Business"!=blank)) as "Busniess Function",count(eval("Line Of Business"=blank)) as "Busniess Function_blank",count(eval("Business Criticality"!=blank)) as "Business Criticality",count(eval("Business Criticality"=blank)) as "Business Criticality_blank",count(eval("Parent Org"!=blank)) as "Parent Org",count(eval("Parent Org"=blank)) as "Parent Org_blank",count(eval("Appl Category"!=blank)) as "Appl Category",count(eval("Appl Category"=blank)) as "Appl Category_blank"
... View more