I want to extract count from list (picture 1 ) to table (picture 2) How do I do?
|stats count by Name,severity |sort - count | stats list(severity) as severity, list(count) as count, sum(count) as Total by Name
| sort -Total
The field severity is follow by name the count for each level inside severity
Ok, now I know the error point thank you Mr.ITWhisperer .
| chart count by Name,severity
| addtotals
I have try, but the information are inaccurate
| stats count by Name,severity
| xyseries Name severity count
| addtotals