Evaluate an if/then expression?

[msarro]

Hey everyone. I am trying to create a dashboard; one of the primary items we're looking to create is a composite score of a number of metrics. Basically if item A is below a certain level it is rated 0, if its above a certain level it is rated 1. This is done for a number of items. The items are then totalled, and divided by the number of items to give us an average. How can I do the branch logic in eval statements? Is it possible?

[gkanapathy · Accepted solution]

There is an if() eval function:

... | eval rating=if(A < level , 0, 1) | ...

[msarro]

Thanks! I actually found it after some searching. Very much appreciated 🙂