https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635102#M220651 <P>Thanks. But now legend values not in sorted order.&nbsp; It is 2020, 2021, 2020 etc..But we need 2020 2020 2021.</P> Mon, 20 Mar 2023 09:48:10 GMT Kirthika 2023-03-20T09:48:10Z https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635084#M220641 <P>I want X axis to be follow the same way as legend order.&nbsp;</P> Mon, 20 Mar 2023 14:59:33 GMT https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635084#M220641 Kirthika 2023-03-20T14:59:33Z https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635094#M220645 <P>You have 3 things in the chart: the x-axis; the y-axis; and, the series. The legend applies to the series not the axis.</P><P>Please share your SPL and clarify what you want the legend to show</P> Mon, 20 Mar 2023 08:29:56 GMT https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635094#M220645 ITWhisperer 2023-03-20T08:29:56Z https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635098#M220648 <P>Sort x axis</P> Mon, 20 Mar 2023 10:19:11 GMT https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635098#M220648 Kirthika 2023-03-20T10:19:11Z https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635101#M220650 <P>The legend is in the order of the series in the table. Chart tries to be helpful by putting these in a sorted order. In order to work against this, you have to do a couple of tricks. Try this:</P><LI-CODE lang="markup">| chart count(Device_ID) over latestversion by Final useother=f | untable latestversion Final count | where count &gt; 0 | eval Final=latestversion."!".Final | xyseries latestversion Final count | transpose 0 column_name=Final header_field=latestversion | eval Final=mvindex(split(Final,"!"),1) | transpose 0 column_name=latestversion header_field=Final</LI-CODE> Mon, 20 Mar 2023 09:42:38 GMT https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635101#M220650 ITWhisperer 2023-03-20T09:42:38Z https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635102#M220651 <P>Thanks. But now legend values not in sorted order.&nbsp; It is 2020, 2021, 2020 etc..But we need 2020 2020 2021.</P> Mon, 20 Mar 2023 09:48:10 GMT https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635102#M220651 Kirthika 2023-03-20T09:48:10Z https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635103#M220652 <LI-CODE lang="markup">| chart count(Device_ID) over latestversion by Final useother=f | untable latestversion Final count | where count &gt; 0 | eval latestversion=Final."!".latestversion | xyseries latestversion Final count | eval latestversion=mvindex(split(latestversion,"!"),1)</LI-CODE> Mon, 20 Mar 2023 09:53:14 GMT https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635103#M220652 ITWhisperer 2023-03-20T09:53:14Z https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635104#M220653 <P>Thank you. It is working perfectly</P> Mon, 20 Mar 2023 09:54:48 GMT https://community.splunk.com/t5/Splunk-Search/Sort-X-axis-based-on-the-value-of-legends/m-p/635104#M220653 Kirthika 2023-03-20T09:54:48Z