topic Re: How to Sort Fields by color using eval and chart? in Dashboards & Visualizations

How to sort fields ?

Marco_Develops — Wed, 20 Apr 2022 16:44:49 GMT

I am currently using a bar chart visualization but I need to sort the bars by descending order.

I can't use a simple chart count by EVNTSEVCAT | sort -count because the SEVCAT field contains multiple values and we only need I,II, and III.

below is my query

The visualization:

sort.PNG

I need the visualization to be sorted in descending order. Any suggestions help :-).

Thank you,

Marco

Re: How to Sort Fields by color using eval and chart?

ITWhisperer — Wed, 20 Apr 2022 16:25:43 GMT

Do you mean sort the names in descending order or the values in descending order?

Re: How to Sort Fields by color using eval and chart?

Marco_Develops — Wed, 20 Apr 2022 16:34:43 GMT

The values in descending order.

The table below represents my bar chart:

sum(CATI)	sum(CATII)	sum(CATIII)
7	141	3

I want the bar chart to sort it out in descending order, so that way sum(CATII) shows first, sum(CATI) second, ,and sum(CATIII) third

-Marco

Re: How to Sort Fields by color using eval and chart?

ITWhisperer — Wed, 20 Apr 2022 16:55:34 GMT

| transpose 0 header_field=cat column_name=cat | sort 0 - "row 1" | transpose 0 header_field=cat column_name=cat | fields - cat

Re: How to Sort Fields by color using eval and chart?

Marco_Develops — Wed, 20 Apr 2022 17:53:12 GMT

@ITWhisperer Thank you I modified it a bit and it works. For people in the future, this is the final query, with the final visualization.

final.PNG

-Marco