Chart Your Way to Richer Data Insights

Intuit QuickBase Charts-are-here-2015-07-21

When it comes to visualizing data, Intuit QuickBase, our low-code app development platform, offers multiple chart types to help you bring your data to life. We’re happy to introduce five new chart types as part of our July product release! These charts enable you to show correlations and relationships among your data, display progress, and measure performance against a specific goal. They make it easier to uncover and communicate rich insights with fewer reports and charts, and help you make your work in QuickBase stand out. All charts are mobile-ready, interactive, and work with dynamic filters.

QuickBase’s recently released line and bar charts allow us to reduce the number of reports and charts in our dashboards, while at the same time, provide a more robust and impactful report portfolio”, says Ed Zacchini, Senior Consultant Operations Manager, EMC.  “These charts will reduce the complexity of how we review and assess disparate reports by consolidating them into a single view.  Now we can analyze how a pre-sales support activity type can impact sales revenue dollars.”

Bubble charts

Use a bubble chart to visualize three dimensions of data on a single chart. Bubble charts are great at showing relationships among your data and conveying a large amount of numeric information quickly— like prospective sales opportunities by close date, dollar amount, and probability of close.  In addition to your standard two dimensions of data (on the x-axis and y-axis), you could include a third dimension represented by bubble size (“probability of close” in the example below). Better yet, you could add a fourth dimension to your data set by varying bubble color (“stage in the sales cycle” on the chart below).

Funnel charts A funnel chart displays progress through any process, for example, a project development cycle or a sales pipeline. The funnel chart below shows the number of projects by stage, from“on hold” through “delivery.”

Gauge charts

The gauge chart is useful in measuring progress against a goal that you set, like your total annual sales. The gauge displays in a single color which is based on the percentage of the goal reached and the ranges you define. For example, you might choose red if the value is less than 50% of the goal, yellow if  the value is 50 – 90% of the goal, and green if the value is greater than 90% of the goal  that you set. On the chart below, our progress towards the sales goal of $1.4 million is marked yellow, as it’s in the range between $700,000 and $1,260,000.

 

Line and bar charts

The line and bar chart combines features of both a bar and a line chart in one visual plot. You can easily distinguish between line values and bar values and visually compare data sets that have different value ranges, like project cost in the millions and project hours in the thousands. The line and bar chart is also effective for visualizing categorical data, like revenue by project type. In the example below, you see trailing twelve months of sales with number of sales deals in the tens and profitability amount in the hundreds of thousands.

Scatter charts 

Scatter charts depict correlations and relationships within your data. They make it easy to visualize how one data set (the x-axis) affects the resulting data set (the y-axis), for example, how project cost affects return on investment (ROI). You can also see trends and outliers at a glance. The SAT Scores chart below shows how math score (on the x-axis) correlates to verbal score (on the y-axis) for two different genders of test-takers.

Want to see the five new chart types in action?  Watch the video demo (4:39 min).

Ready to explore how the new chart types can help you create more visually compelling and informative reports? Take a look at the examples in our charts app from QuickBase Exchange. Feel free to substitute your data for the sample data, and show off your amazing charts in the comments of this blog post, below.  Happy charting!

Download our charts app from QuickBase Exchange.

Not yet utilizing QuickBase? Request a demo or start a free 30-day trial now.

You may also like:

Posted in Product Announcements, Product Info | Tagged , , , , , ,
  • Eric James

    On my scatter chart, I created a new formula numeric field that summed the verbal and math scores to give the total score. I then changed the Y axis to display this new “Total Score” field to show the relationship between verbal scores and total score. I also trimmed the outliers by using filters.

    • Mariana St.Germain

      Hi Eric,

      Thank you for sharing your scatter chart example! I hope you find good use for the new charts and enhance the way you use QuickBase.

  • I like the new gauge charts to provide quick glance information for our executive team. A great example: number of employees or number of active projects.

  • josh miller

    This has been a long awaited feature. It has been very useful thus far. Can’t wait to see what chart type Quickbase comes up with next (Infographics).

  • Matt Sarver

    I love that we can now have a chart with 2 Y axis, and it allows for more powerful visualization of relationships.

  • Brendon S

    wow, kudos Quickbase. I have been using custom scripts and a plugin called JustGauge to use gauge charts in our apps. What a time saver to have them readily available now. Here is one of mine using the new QB gauge chart

  • Mark Shnier

    Definitely good to see more Chart Types. I would like to see an enhancement to the two chart types with a Goal (Bar Chart with Goal and Gauge) so that the Goal can refer to a field value and not be fixed. For example, it would be nice to be able to use these for Sales Rep Goals where each rep has a different Annual Quota target.

    Having said that, the work around for the Bar Chart with Goal chart is to use the line and bar chart type which is similar, and to have a formula for the monthly Goal being the Line. But I don’t see the work around to the Gauge Chart type to make the goal dynamic from the data.

  • Dan Richard

    Let the charting begin!

  • T Nor

    Very cool!

  • Dinesh Vijayakumar

    I was waiting for this update to have a chart that combines bar and line combined in a single chart. Thanks QuickBase for the update.

  • Tina Hand

    It’s not that easy or I just don’t understand how to get it to interact with my data.

  • M A

    The trend chart was the most awaited (bar+line chart). I’m sure it will save a lot of our effort now.

  • Mohit Chawla

    I tried the funnel chart. Good to have an alternate to Pie charts
    I didn’t find the upload button to share the chart I created. May be a browser issue

  • Lizzie10 Hill

    We’ve been using the “What’s For Lunch” app that was mentioned a while ago as a sandbox area/useful tool. I decided to chart some of its info – only to discover that people have *not* been reviewing the local eateries. Alas, this leaves me woefully short of data to chart. I finally charted the distance from the office, the type of restaurant, and the number of reviews.
    P.S. My fave is Livelihood Cafe

    • Lizzie10 Hill

      Today I put our (bored) summer intern to work playing with the downloaded Charts are Fun app. He was amazed at the things he could make it do. Now he just needs to teach the rest of us.

  • Randi

    The funnel chart was very simple to create. These charts will come in very handy when a visual presentation is needed on the fly.

  • Pingback: When to Use Bubble Charts to Display Your Data | The Fast Track()

  • Joe Lichtefeld

    I like all the new charting options. New features are always welcomed.

  • ABCole07

    I just made my first chart with this and I love it for two reasons:

    1. I have a easy to digest representation of the volume our event team is working with.
    2. I can easily see the logjams occurring in the process and can work to address them.

  • Dove

    Very good article. I will be exploring how this will be useful for our organization

  • Doug M

    The funnel charts are my chart of choice from the new additions. Going to put it to action now.

  • Doug M

    my supplier chart for service #s

  • Cindy Follis

    I used a line chart to track billing trends

  • Joe Scola

    Great addition – after trying to incorporate google charts as an option these are a breeze to set up and provide KPIs we have been wanting.

  • Joe Scola

    Great addition – after trying to incorporate google charts as an option these are a breeze to set up and provide KPIs we have been wanting.

  • John Leuver

    Here is a chart I made, gauging my distance to Eutopia. Whoop. Looks like I’m already there.

    • Davin Wilfrid

      Lookin’ good John!