Creating Interactive Patch Compliance Dashboard in QuickSight Using AWS SSM Patch Data

I am currently working on building a patch compliance reporting dashboard in QuickSight using the data from AWS SSM Compliance. The goal is to generate two separate dashboards one for prod and another for Non- Prod.
We have patch groups already defined in SSM but when I am creating Dataset I don’t see field for Prod and Non prod.
I am not able to create interactive if select non-compliant section filters down and display list of affected servers.
I am not able to create separate data views for Prod and Non prod environments.
Can someone please guide me on the steps or architecture needed to achieve this.

Hello Amuqtader,

First of all welcome to the QuickSight Community.

I suggest to refer this blog to get some idea and adjust accordingly.

Hope this helps.

Cheers,
Deep