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."
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."
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 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.