Dataset formula for severity types

I have a dataset with alert details from a monitoring software. I’d like to make two columns that count the number of critical and Severe tickets for displaying in a dashboard. When I try a few basic SQL statements, it rolls up the database into one line, with most of the info from the last line in the DB. What is the correct way to do this without having two or more databases (one for each severity)?

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.