Charts are useful for showing patterns in the data. Line, bar, and pie charts show two dimensions of data. When you need to see more information on a chart, consider using a bubble chart, which allows you to display as many as four dimensions of data. In addition to the x and y-axis, the size of the bubble represents a third dimension and the color of the bubble can be used to represent a fourth dimension.
How it works
Bubble charts are an ideal way to display records in Aha!, such as ideas or features, weighted by their score values. With the bubble chart, you can create a matrix view that displays records with higher scores as larger bubbles and records with lower scores as smaller bubbles.
Creating a bubble chart starts from the Reports > List page. This is where you select the data you wish to display in the chart and format it in a way that will automatically translate into a bubble chart.
In this example, a simple bubble chart is being created from ideas using the idea name, effort score, value score, idea status, and total idea score values.
The columns for your list report need to be in this order to transfer to the bubble chart correctly:
|Variable Name||x-axis value||y-axis value||Color of the bubble||Size of the bubble|
|Idea 1||Effort score||Impact score||In Design||Total score|
|Idea 2||Effort score||Impact score||Ready to Develop||Total score|
Choose your data columns and filters
From the Reports > List page, click the Add data button on the upper left of the page. When adding data to any report, it is important to remember that all data displayed will be in relation to the primary record selected.
In the below example, ideas were selected as the primary record. The product and feature tables were added later. This is visualized by them being indented beneath the idea table. This means any product or feature data displayed would be displayed in relation to ideas. If you select to show feature names, for example, only features related to an idea would be displayed.
Add filters as necessary through the Add filter button. A common filter when creating a bubble chart would be to filter by product name to ensure the data is from one specific product and also to potentially filter the score value. In this example, idea scores were filtered to only display ideas with a score greater than 1.
Organize and sort the data
After adding all of the data columns that you want to display to the list report, organize the columns so that they are in the correct order for translating into the bubble chart. You can reorder the columns by clicking on the column name and then dragging it left or right.
The required fixed order of your columns for then converting into a bubble chart should be the variable name, x-axis value, y-axis value, color of bubble value, and size of bubble value.
Convert to the bubble chart
After you have organized your data, click the Chart data button to transition the data over to the Reports > Chart. This will allow you to select the bubble chart and customize the formatting.
The size of your bubbles will be automatically generated based on the values in the fifth column of your Reports > List page. You may customize the labels for your chart and the colors of the bubbles by selecting the Customize option.
With your bubble chart type selected and customizations completed, you can click OK, save the view, and share it with your team through Aha! Notebooks.