title: How to get the records with mutiple mandatory record values in kusto
body: <p>I'm new to kusto functions and i need to get the data for 1 day which should include all the states in that day.
  For ex: my raw data looks like the below image</p>
  <p><a href="https://i.stack.imgur.com/YC9kR.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>Now I wanted to get the records per day which should have both job states (Running and Completed). Can someone please help me how to get this ?</p>
  <p>I should get this one</p>
  <p><a href="https://i.stack.imgur.com/NNBHs.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>Thanks in advance</p>