Grid showing total by count based on 2 separate columns

[lfk32]

I need to display a grid which uses two axes to show a total (by count) of occurrences of 2 values.  To make it a little more complicated one of those values is a range of number.  

Looking at the sample data i need to count the total occurrences of:

Sev 5 with CVSS 0.0-3.9

Sev 5 with CVSS 4.0-6.9

Sev 5 with CVSS 7.0-10

Sev 4 with CVSS 0.0-3.9

Sev 4 with CVSS 4.0-6.9

Sev 4 with CVSS 7.0-10

Sev 3 with CVSS 0.0-3.9

Sev 3 with CVSS 4.0-6.9

Sev 3 with CVSS 7.0-10

And so on for Sev 2 and Sev 1

It would look something like this:

I have done this with by creating cards and applying manual filters to the values already in the table however since the filters are applied manually at the time i create the card this does not work if a new value appears in the table.  For example, when i apply the filter to the card there is no 5.5 to select but later a fresh import brings in a 5.5 but the card doesn’t include that value.

I’m thinking maybe a calculated sum based on the Sev number (e.g. 5) and a range for CVSS (e.g. 0.0-3.9).  Then i just put that into the card.

Any suggestions on how i do this?

[amitchandak]

@lfk32 , A new column like this can help

cvss Range =
SWITCH (
TRUE (),
[cvss] >= 0.0 && [cvss] <= 3.9, "0.0-3.9",
[cvss] >= 4.0 && [cvss] <= 6.9, "4.0-6.9",
[cvss] >= 7.0 && [cvss] <= 10.0, "7.0-10",
BLANK ()
)

Then with Sev name columna and measure countrows(Table) can help

[lfk32]

I think i worked out a way but still interested to hear ideas.  Maybe someone knows a more streamlined way to do it