Modern Dashboard - KPI Widget - All Alert Count for Acknowledged & Unacknowledged Alerts for a specific group

That join aint right

I've got stuff like this in prod, but the query can look quite a bit different based on environmental specifics

I think you want to join to at least a couple other alerts tables, and then to ContainerMembers where the memberID = AlertObjectID or similar.
Note if you've got groups in groups this can get a bit weird

If the groups are to do with some datapoint it's maybe worth commiting the datapoint to some properties for less joins. Maybe not, depends on your structure.

There's some code examples on here already for SWQL alerts queries, many are better than what I use already

Thank for the review Adam. I am still in process to learn more about SWQL queries. Is it possible to share a sample query that you are using. Leveraging the same i can try moving further 

msseversum's got some resources over here thwack.solarwinds.com/.../custom-sql-swql-for-alerts-history---sla-reporting

If you want to actually count stuff, it's COUNT(columnname) .... GROUP BY Something if need be