Parse Same Field Multiple Times

Comments

2 comments

  • Avatar
    Rick Jury

    try 
    "query"
    | parse "myNum = * " as n
    | if (n > 1 , "2+",n) as n
    | timeslice by 15m
    | count by n,_timeslice
    |transpose row _timeslice column n

    0
    Comment actions Permalink
  • Avatar
    mehdi.zarekani

    That doesn't really work but it gave me an idea of what to do:

     if (n != 1 and n !=0 , "Not Zero or One",n) as n

     

    I guess I just assumed that I couldn't have multiple conditions in an if statement. 

    0
    Comment actions Permalink

Please sign in to leave a comment.