Querying using if statement

Follow

Swapnil Modak

• July 06, 2020 18:45

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.

0

• 

  Latimer Luis

  • July 06, 2020 19:22

  This should work if you nest the IF statements, similar to what you'd need to do in MS Excel: 
  
  | if(values in ("A","B","C"),"High",if(values in ("D","E","F"),"Medium",if(values in ("G","H","I"),"low", ""))) as Severity

   

  0

  Comment actions Permalink
• 

  Swapnil Modak

  • July 06, 2020 20:39

  Thanks Latimer Luis. It is working as expected

  0

  Comment actions Permalink

Please sign in to leave a comment.