I'm displaying Failures and Delays of some processes running daily, i need to make a dashboard where i have to show the volatility of a process, like if the process is getting failed and delayed for the same execution date i should get volatilty value count as 1. Can anybody help me how to construct a eval query with some condition so if Delay count =1 and Failure count=1 for a particular execution date, the volatility count should come as 1. please help
