Hi,
I’m trying to make a pie chart with the categories of vulnerabilities grouped by their name.
The result at the moment is the one in the picture below.
The count of the single vulnerabilities is correct, as this is just a test so there are just a few records in the database.
However, I was wondering why grafana picks the same color for the last two vulnerabilities.
It seems that the color pick is the same when the value is the same (1 for SQLi and 1 for XSS).
At the moment the query is as simple as:
SELECT title, COUNT(severity) FROM vulnerability GROUP BY title LIMIT 50
Also, how do I change the “LIMIT” value in the UI without having to change it manually in the query?
Any suggestion is appreciated.