Querying using if statement
Hi,
I need to know how can we get the count based on below example
1) if values in("A","B","C"),"High","") as Severity
|if values in("D","E","F"),"Medium","") as Severity
|if values in ("G","H","I"),"low", "") as Severity
count by Severity
In above situation i only see last if count i.e. "if values in ("G","H","I"),"low", "") " under Severity column but not the High and medium, How can i have count of individual high,low, medium.
-
Thanks Latimer Luis. It is working as expected
Please sign in to leave a comment.
Comments
2 comments