One of the most resource intensive functions in a chart is the If statement. In a lot of scenarios, what you can do is leverage the combination of Pick and Match to replicate the functionality while increasing performance.

Example

pick match

pick match

If you need an Else condition, there is a neat little trick you can do by adding a ‘+1’ and making the first option the Else result:

pick match