https://community.splunk.com/t5/Splunk-Search/pareto-chart/m-p/108185#M28142 <P>thanks lukejadamec: after playing around a bit with the syntax, i was able to get it working with:</P> <PRE><CODE>chart count(duration) AS total_duration by directorate | sort -total_duration </CODE></PRE> <P>hope this helps someone!</P> Tue, 22 Oct 2013 01:30:09 GMT ytl 2013-10-22T01:30:09Z https://community.splunk.com/t5/Splunk-Search/pareto-chart/m-p/108182#M28139 <P>hi, i have some data that i would like to display a bar chart with; however, i would like the x-axis items to be ordered by the frequency of the item itself - ie a pareto chart (i would also like the accumulative on a second y-axis, but that's less important). can any one help me with this please?</P> <P>my search is quite simple:</P> <PRE><CODE>chart sum(duration) by directorate </CODE></PRE> <P>which gives me two columns (directorate and sum(duration)) in the 'statistics' tab.</P> Mon, 21 Oct 2013 21:49:52 GMT https://community.splunk.com/t5/Splunk-Search/pareto-chart/m-p/108182#M28139 ytl 2013-10-21T21:49:52Z https://community.splunk.com/t5/Splunk-Search/pareto-chart/m-p/108183#M28140 <P>Can you post your search string, and have you tried sorting?</P> Mon, 21 Oct 2013 22:51:57 GMT https://community.splunk.com/t5/Splunk-Search/pareto-chart/m-p/108183#M28140 lukejadamec 2013-10-21T22:51:57Z https://community.splunk.com/t5/Splunk-Search/pareto-chart/m-p/108184#M28141 <P>add my search to question - thanks lukejadamec, i'm not sure how i would include the sort function into the chart...</P> Tue, 22 Oct 2013 00:37:01 GMT https://community.splunk.com/t5/Splunk-Search/pareto-chart/m-p/108184#M28141 ytl 2013-10-22T00:37:01Z https://community.splunk.com/t5/Splunk-Search/pareto-chart/m-p/108185#M28142 <P>thanks lukejadamec: after playing around a bit with the syntax, i was able to get it working with:</P> <PRE><CODE>chart count(duration) AS total_duration by directorate | sort -total_duration </CODE></PRE> <P>hope this helps someone!</P> Tue, 22 Oct 2013 01:30:09 GMT https://community.splunk.com/t5/Splunk-Search/pareto-chart/m-p/108185#M28142 ytl 2013-10-22T01:30:09Z