--- title: "Report Builder Walkthrough: Plotting a Non-Numeric Column on a Chart" description: Non-numeric columns can still become points or bars in your chart. --- [Skip to content](https://support.angeltrack.com/help/reporting/walkthrough_plottingnonnumericcolumn.htm#main-content) English Show submenu for translations ![A.400x400.png\]](https://support.angeltrack.com/hs-fs/hubfs/A.400x400.png?height=40&name=A.400x400.png) Open main navigation Close main navigation - English Show submenu for translations - Go to angeltrack.com Go to angeltrack.com AngelTrack Knowledge Base - There are no suggestions because the search field is empty. 1. [AngelTrack Knowledge Base](https://support.angeltrack.com/help?hsLang=en) 2. [Report Builder](https://support.angeltrack.com/help/report-builder?hsLang=en) 3. [Walkthroughs](https://support.angeltrack.com/help/report-builder?hsLang=en#walkthroughs) # Report Builder Walkthrough: Plotting a Non-Numeric Column on a Chart ## Non-numeric columns can still become points or bars in your chart. Although every chart can have any *category* column of your choosing, its *data* columns -- which get plotted as bars or points or lines -- must be *numeric* data. That means you cannot plot values like "Emergent" or "Condition Green" or "ALS" as your chart's data points. If you are wanting to plot those, it is probably because you are trying to plot *the count of rows that have those values*.  In other words, you are probably trying to plot the number of calls that are "Emergent" or "Condition Green" or "ALS" or "brush fire", versus the number of calls that are not. To achieve this, in the sidebar, drag the desired column down to the "Row Groups" box, and then drag the "Dispatch ID" column (or other record ID column) down to the "Values" box and change its aggregation function to COUNT. You can then chart the result, and it will show a count of rows for each of the values in the desired column. ### Example Walkthrough 1. From the Data Hub, select the "Dispatches-Overview" dataset, and then click the "Launch New Report" button. 2. From the report's sidebar, in the "Columns" tab, deselect all columns by clicking the uppermost checkbox, the one next to the "Search" box. 3. Still in the sidebar, drag the column "Service Level Provided" down to the "Row Groups" box. 4. Still in the sidebar, drag the column "Dispatch ID" down to the "Values" box, and then click it to change its aggregation function from SUM to COUNT. 5. From the grid, click and drag to select all visible rows and columns. 6. Right-click the selection area, select "Chart Range", and select "Pie", and then "Pie". Here is how your completed chart will look: ![ReportBuilder.SimpleChart.3](https://support.angeltrack.com/hs-fs/hubfs/ReportBuilder.SimpleChart.3.png?width=688&height=455&name=ReportBuilder.SimpleChart.3.png) This kind of report is ideal for pivoting, so take a look at the help for pivoting and pivot charts. - [General Topics](https://support.angeltrack.com/help/general-topics?hsLang=en#main-content) - [Configuration](https://support.angeltrack.com/help/general-topics?hsLang=en#configuration) - [Integrations](https://support.angeltrack.com/help/general-topics?hsLang=en#integrations) - [State and County Uploads](https://support.angeltrack.com/help/general-topics?hsLang=en#state-and-county-uploads) - [Dispatch](https://support.angeltrack.com/help/dispatch?hsLang=en#main-content) - [Basic Dispatch](https://support.angeltrack.com/help/dispatch?hsLang=en#basic-dispatch) - [Schedules and Recurrences](https://support.angeltrack.com/help/dispatch?hsLang=en#schedules-and-recurrences) - [Connections to Billing](https://support.angeltrack.com/help/dispatch?hsLang=en#connections-to-billing) - [Advanced Topics and Tips](https://support.angeltrack.com/help/dispatch?hsLang=en#advanced-topics-and-tips) - [Vertex AI Dispatch Planner](https://support.angeltrack.com/help/dispatch?hsLang=en#vertex-ai-dispatch-planner) - [Supervisors](https://support.angeltrack.com/help/supervisors?hsLang=en#main-content) - [Fleet](https://support.angeltrack.com/help/supervisors?hsLang=en#fleet) - [Compliance](https://support.angeltrack.com/help/supervisors?hsLang=en#compliance) - [Billing](https://support.angeltrack.com/help/billing?hsLang=en#main-content) - [Invoicing](https://support.angeltrack.com/help/billing?hsLang=en#invoicing) - [Pricing and Contracts](https://support.angeltrack.com/help/billing?hsLang=en#pricing-and-contracts) - [Coding, Claims, and Clearinghouse](https://support.angeltrack.com/help/billing?hsLang=en#coding-claims-and-clearinghouse) - [Prior Authorization and PCS](https://support.angeltrack.com/help/billing?hsLang=en#prior-authorization-and-pcs) - [Billing Workflow](https://support.angeltrack.com/help/billing?hsLang=en#billing-workflow) - [Payments and EOBs](https://support.angeltrack.com/help/billing?hsLang=en#payments-and-eobs) - [Facility and Patient Records](https://support.angeltrack.com/help/billing?hsLang=en#facility-and-patient-records) - [QA Review](https://support.angeltrack.com/help/qa-review?hsLang=en) - [Salesperson](https://support.angeltrack.com/help/salesperson?hsLang=en) - [Human Resources](https://support.angeltrack.com/help/human-resources?hsLang=en#main-content) - [Timeclock](https://support.angeltrack.com/help/human-resources?hsLang=en#timeclock) - [Schedules and Vacations](https://support.angeltrack.com/help/human-resources?hsLang=en#schedules-and-vacations) - [Crew Members](https://support.angeltrack.com/help/crew-members?hsLang=en#main-content) - [Report Completion](https://support.angeltrack.com/help/crew-members?hsLang=en#report-completion) - [Documents](https://support.angeltrack.com/help/crew-members?hsLang=en#documents) - [Fire](https://support.angeltrack.com/help/fire?hsLang=en) - [IT](https://support.angeltrack.com/help/it?hsLang=en#main-content) - [Data Protection](https://support.angeltrack.com/help/it?hsLang=en#data-protection) - [Troubleshooting](https://support.angeltrack.com/help/it?hsLang=en#troubleshooting) - [Miscellaneous](https://support.angeltrack.com/help/miscellaneous?hsLang=en#main-content) - [Articles for patients and facilities](https://support.angeltrack.com/help/miscellaneous?hsLang=en#articles-for-patients-and-facilities) - [Report Builder](https://support.angeltrack.com/help/report-builder?hsLang=en#main-content) - [Walkthroughs](https://support.angeltrack.com/help/report-builder?hsLang=en#walkthroughs) - [Built-In Reports](https://support.angeltrack.com/help/report-builder?hsLang=en#built-in-reports) [![Chill listening crop-3](https://support.angeltrack.com/hs-fs/hubfs/A.400x400.png?width=40&height=40&name=A.400x400.png "Chill listening crop-3")](https://support.angeltrack.com/help/index.htm?hsLang=en) AngelTrack Support Home Copyright © 2026, AngelTrack LLC