Thanks for reading. its been a while since i have written some of these queries and i am not able to get what i need to work just right. I am doing a query for exceptions of a specific type and operation.

I want to compare todays count with yesterdays count and put it into a single table. which will them be used in a logic app.

Columns would look something like

Exception Type, Operation Name, Todays Count, Yesterdays Count

Its very easy to get all but that comparative count. Every way i have tried to get it nicely rolled into one has failed. How would you structure the query? or if you have some good links to examples i would love that too,.