Bubble charts use the x and y-axis data as coordinates for the data points on the graph, while including a third
dimension: size. The larger the size of the bubbles in the chart, the larger the indicated value. In this example,
a larger bubble represents a higher level of profits.
Run your SQL query that returns 3 to 5 columns. Three columns are required to generate the chart; the two columns
of values used for the x and y-axis, as well as a third column of values indicative of a value scale to generate
the bubble size. Refer to the following data table to see how we generated the bubble chart.
- x: The bubble chart's x-axis, which is the ‘Qty‘ column for quantity, which uses the number data type.
- y: The bubble chart's y-axis, which is the ‘Margin’ column for profit margins, which uses the number data type with 'Percent' as the format for percentage values.
- z: The bubble chart's third dimension of values to derive bubble size, which is the ‘Profits’ column for product profits, using the 'Currency' and 'Dollar' format for the dollar values.
- label (optional): The ‘prod_name’ column values attaches the product name label to each of the bubble chart’s individual data points, using the string data type.
- group (optional): This column categorizes and colour codes the bubbles by their grouping, which is by phone product company's brand in this example based on the ‘prod_brand’ column, which uses the string data type.
Access the Visualization Editor at the bottom of the Report Editor screen, and select the 'Bubble' chart option
button. If you have built your SQL query correctly to return the necessary columns, Holistics will then plot
the data columns as a bubble chart, as per this example.