Can I create a bar graph that displays multiple fields?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Here's what I'm trying to do, create a graph that gives a total number of prospects from each source on one bar, and display next to that bar the total number of loans closed from that source. Example: one source is "previous customers", I would like to graph a total number of prospects that were "previous customers" and a total number of loans closed that were "previous customers" in a given time frame. Thanks for your input.

Photo of DelRay

DelRay

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Daniel A

Daniel A

  • 40 Points
Hello DelRay,

So based on your requirements, it maybe simpler to use a Summary Report to display the difference total based on the prospects. (review help topic)


http://www.quickbase.com/user-assistance/Default.html#about_the_summary_view_page.html



Otherwise, you would need to create a field titled for each source (like a check box or Number for 1 for the source and 0 for the other sources that are not associated with the record). Then you can use the different source fields as your x-axis values to show against for the different Bars on the chart.

I hope that helps.

Best,
Quickbase Customer Care Team