Expand my Community achievements bar.

Are Pareto charts possible?

Avatar

Level 2
Hello Everyone, I'd like to do something the WF Help folks have apparently said isn't possible, but I thought it would be worth putting out to the community too. You're all very smart and creative, and I think this one may give your creativity muscles a bit of exercise. I'd LOVE to create a Pareto chart for some of my data. The definition of a Pareto chart (from the "https://en.wikipedia.org/wiki/Pareto_chart">Pareto Chart Wikipedia article ) is " a type of chart that contains both "https://en.wikipedia.org/wiki/Bar_chart" title="Bar chart">bars and a "https://en.wikipedia.org/wiki/Line_chart" title="Line chart">line graph , where individual values are represented in descending order by bars, and the cumulative total is represented by the line." Here is a picture of what they can look like (also from "https://en.wikipedia.org/wiki/Pareto_chart">the Wikipedia article ): Sometimes the line just starts from the top of the first column and grows from there. Either way is acceptable. In my particular case, I have a pile of WF Issues. Each Issue has been categorized via a custom drop-down field. I'd like to make a Pareto chart based on the # of issues in each category. I know about Workfront's "Combination Chart" fuctionality inside Bar and Column charts. Seems like it should work with that, right? But no luck, at least so far. There are two things I've been unable to make WF do: List the columns in descending order by count (WF lists them alphabetically), and Show the line as a cumulative value (WF only shows the count of each category and the line just follows the columns). There you go. Something to chew on, anyway. I'm looking forward to seeing what you all come up with. Best Regards -- Matthew Brinkerhoff doTERRA
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10
Hi Mathew, Workfront used to support Pareto charts, but according to my notes, they didn't make the cut (presumably due to lack of popularity) around the 2013/2014 time frame. To construct one with what's now available within native Workfront Reporting might be possible, my hunch is that a third party approach such as our "http://store.atappstore.com/product/magic-reports/">Magic Reports solution might be the best path. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads