Pie Reports | BASICS
What is A Pie Chart?
The central idea of the pie chart is that you’re comparing parts to the whole. Slices of different size are marked on a circle (i.e the pie) based on what part of the whole they represent. For example, say you have a grocery store with three departments and you look at revenue from each. The sum of all the revenue figures is the same as your total revenue, and you can look at each department and see how much (i.e. the percentage) it contributes.
Below is an example of what this might look like:
Creating a Pie Chart
- From the Table bar, choose a table you would like the Pie chart to live in.
- Select Reports & Charts to open the reports and charts panel, then click +New.
- Select Chart from the list and click Create.
- Add a name and description.
- In the Reports & Charts panel section, determine who can see this chart.
When you save this type of report, you will have several choices to choose from. Each option will have a brief description next to them to help you select the best option.
! EDITORS NOTE: An app manager can also specify which reports a particular role can see at any time. To learn how, see: Displaying Information for Certain Roles | BEGINNER.
- In the Chart Details section there will be a drop – down menu called, Select a type of chart. In this drop – down, select the Pie Chart option.
Once the chart type is selected, a picture of the chart type will appear in addition to a small section to the right known as the Legend with a brief description underneath.
- Within the Chart Details section, select a field whose values you want to display as the Series.
Quick Base allows the option on how to group the data from the field selected by using the Group By option. Use this drop – down to display the data in intervals or set amounts. For example, if your pie chart features a numeric field, you can show amounts in groups of fives, tens, hundreds or by dates of month, quarter, year.
EDITORS NOTE: After you select the field whose values you want to appear as wedges on your chart, Quick Base will display these values in the Report Builder’s Legend box, which shows you what values will eventually display. If you want to customize the colors for these values, click a color swatch to display the color chooser.
- Within the Chart Details section, select the Data values you want to show.
Use the Data values section to select your measures and whether or not you want the sum or average of these values. For example, you might want to show annual or quarterly revenue of a company by department, or measure salesperson contribution by number of sales.
EDITORS NOTE: The field you choose here contains the numbers that determine the size of each pie wedge. Please keep in mind that this field will only list numeric field types and not text.
- Use the Sorting and Data labels sections to decide how to sort and display values in your pie chart.
- Use Filters to define the results.
Within the filter section you can tell Quick Base what records to include. If you want your chart to show only a certain kind of record or only records that meet specific conditions, you can do so here. For example, maybe you only want to show company revenue by department in quarter three, or maybe you’d only like to see sales of a particular category of products, such as headphones, and not your other products. Is so, this is the section where you can make all these adjustments within your chart.
To learn more ways to customize your reports in Quick Base, check out more articles here: Reporting & Dashboards.
- Author: Alex Skudrovskis (firstname.lastname@example.org))
- Date Submitted: 3/20/2019