https://community.splunk.com/t5/Dashboards-Visualizations/Sorting-the-values-for-the-chart/m-p/102679#M5783 <P>If the fields are clearly defined and the fields have the appropriate data, then you can use the following to complement your search:</P> <PRE><CODE>| chart list(Diff) AS Diff by TaskName </CODE></PRE> <P>That should do it. Let us know if this works.</P> Thu, 25 Oct 2012 14:37:23 GMT Gilberto_Castil 2012-10-25T14:37:23Z https://community.splunk.com/t5/Dashboards-Visualizations/Sorting-the-values-for-the-chart/m-p/102678#M5782 <P>| savedsearch "searchduration" | join TaskBP [ | savedsearch "searchavgduration" ]|eval Diff=duration-Avgduration|table TaskBP Diff|</P> <P>after running this query ,i got the output as</P> <P>TaskNmae Diff</P> <P>A -345</P> <P>B -122</P> <P>C 867</P> <P>D 111</P> <P>What i need is i want to plot the chart so that the negative charts sholud be upside down and the positive values should be upside Top</P> Thu, 25 Oct 2012 12:03:31 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Sorting-the-values-for-the-chart/m-p/102678#M5782 splunkpoornima 2012-10-25T12:03:31Z https://community.splunk.com/t5/Dashboards-Visualizations/Sorting-the-values-for-the-chart/m-p/102679#M5783 <P>If the fields are clearly defined and the fields have the appropriate data, then you can use the following to complement your search:</P> <PRE><CODE>| chart list(Diff) AS Diff by TaskName </CODE></PRE> <P>That should do it. Let us know if this works.</P> Thu, 25 Oct 2012 14:37:23 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Sorting-the-values-for-the-chart/m-p/102679#M5783 Gilberto_Castil 2012-10-25T14:37:23Z https://community.splunk.com/t5/Dashboards-Visualizations/Sorting-the-values-for-the-chart/m-p/102680#M5784 <P>hi Glib,</P> <P>i tried it shows the TaskName and the List od Diff values ..but it shows some error as "chart has limited size due to that some values got ignored and truncated"</P> Fri, 26 Oct 2012 04:56:39 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Sorting-the-values-for-the-chart/m-p/102680#M5784 splunkpoornima 2012-10-26T04:56:39Z