I’ve done about the same thing with session relevance:
You can check this post out and filter on what you need. My query gives a compliance percentage for all the critical patches from the last month. Lee Wei added the computer group. So if you adjust it a little bit, you can have what you need. You can also use Lee Wei’s report, depending on what you need ofc.