Reports & Charts - Creating a Pareto Chart
I am trying to create a Pareto Chart. I've selected a "Line and Bar" for the Chart Type. I am trying to figure out how to add the line graph that showcases the cumulative percentage of events. I as...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendQuickbase does not currently have a Pareto Chart. That aspect of "cumulative' only exists in the waterfall type report.
So I see two options. Work with either free or paid services from "The Quickbase Junkie" @Sharon Faust such as this free video https://www.quickbasejunkie.com/blog/how-to-cumulative-charts
to calculate the cumulative field using a Formula Query. There are also help text natively in Quickbase but Sharon has great examples to follow.
Alternatively, you could use the third party add on from Juiced Technologies called XL Docs to click a button to create an excel sheet with the chart that you built in the Excel template. But then you end up with an excel sheet and obviously not as elegant as just running a Quickbase report.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
So I see two options. Work with either free or paid services from "The Quickbase Junkie" @Sharon Faust such as this free video https://www.quickbasejunkie.com/blog/how-to-cumulative-charts
to calculate the cumulative field using a Formula Query. There are also help text natively in Quickbase but Sharon has great examples to follow.
Alternatively, you could use the third party add on from Juiced Technologies called XL Docs to click a button to create an excel sheet with the chart that you built in the Excel template. But then you end up with an excel sheet and obviously not as elegant as just running a Quickbase report.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I was able to create a Pareto Chart in QuickBase :) I had to write 5 different formulas, but its perfect! The only thing left is to figure out how to filter the Pareto Chart!!!!
------------------------------
Kelsey Poole
------------------------------
@Kelsey Poole, thanks for posting the pareto report job aid!
Pareto job aid
------------------------------
Adam Keever
------------------------------
