How to display CVE as a number not all the CVE's listed

[rkaakaty]

My CVE field is being displayed like this:

I want it to be displayed by the number of CVE's and not each one.

Here is my code:

index=nessus cve=*
| eval CVSS_SCORE = cvss_base_score + cvss_temporal_score
| eval description=substr(description,1,100)
| eval solution=substr(solution,1,100)
| rename id as ID, cve as CVE, plugin_name as Plugin_Name, description as Description, solution as Solution
| table ID, Plugin_Name, Description, Solution, CVSS_SCORE, CVE
| sort - CVSS_SCORE

[somesoni2 · Accepted solution]

Try this

index=nessus cve=*
| eval CVSS_SCORE = cvss_base_score + cvss_temporal_score
| eval description=substr(description,1,100)
| eval solution=substr(solution,1,100)
| eval CVE=mvcount(cve)
| rename id as ID, plugin_name as Plugin_Name, description as Description, solution as Solution
| table ID, Plugin_Name, Description, Solution, CVSS_SCORE, CVE
| sort - CVSS_SCORE

[rkaakaty]

Thank you!