Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
@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
I think i worked out a way but still interested to hear ideas. Maybe someone knows a more streamlined way to do it
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |