A Lookup field brings a value from a linked record onto this record, without copying it. A chart treats the lookup like a field of the type it looks up. A lookup of a select field is counted and drawn one bar, slice or series per value, and it is offered under Group By. A lookup of a number is offered as a value with a function.
Here is the test: is the field you want to chart on the linked table, not on this one? If yes, add a Lookup field for it and chart the lookup. See Lookup Field.
Example: a Vendor Management solution where Findings links to Vendors through a Vendor field. Findings has a Lookup field called Vendor Tier that shows the tier of the finding's vendor. The Security lead builds a bar chart of findings per tier from that lookup, so the count per tier appears without a tier field on Findings. Finance adds a second lookup, Annual Contract Value through Vendor, to sum the contract value behind each finding owner.
The Values dropdown in Chart Settings with the Vendor Tier lookup listed, marked with the lookup icon of two overlapping squares.
Plan Availability | All plan types. |
Permissions | Full Access members and Solution Managers create and change public views; every member creates private views. |
Platform | Web |
Related Reading |
Opening the pickers
Open the Chart Settings sidebar in a Chart view, or the Chart widget's settings on a dashboard. The table's fields are listed in two places: the field dropdown of each Values row and the Select Field dropdown under Group By. Both lists are alphabetical and have a search box. A Lookup field appears under its own name with a lookup icon, two overlapping squares, beside the table's own fields. The Linked Record field it reads through is listed too.
A field with more than one way to read it is listed more than once. A Status field appears as Status value and Status completed or not. A Date field appears under Group By as its value and as overdue or not, and is not offered as a value.
A Lookup as a value
Pick the lookup in a Values row. A lookup of a Single Select or Status field takes Count, fixed as for the select itself. The chart then draws one bar, column, slice or series per value of the lookup. For Vendor Tier with Count, a bar chart draws one bar per tier and the legend lists Tier 1, Tier 2 and Tier 3. Records with no linked vendor have no tier and are left out until Include empty values is checked under Advanced Options.
A lookup of a numeric field is offered with a function. For the example, Finance picks the Annual Contract Value lookup with Sum.
A lookup of a select field is not offered for Chart Total, X-Axis, Y-Axis or Bubble Size, which list numeric fields only.
Note: A lookup can return several values for one record, when the record links to several records. The chart counts each value, so a total can be higher than the record count.
A Lookup as the Group By
The Group By dropdown offers the lookup with the same icon. Pick it and the chart groups by the looked-up value. The live article lists the lookup types that group :
A Number: one group per value.
A Date: one group per date, with the period dropdown.
A Linked Record: one group per linked record.
An Assigned To: one group per member.
A list field such as Single Select, Multiple Select or Tag: one group per choice.
For the example, the Security lead picks the Vendor Tier lookup under Group By for a column chart of findings by severity. Each tier becomes a cluster with one column per severity.
Tip: Group a child table's chart by a parent field through a lookup instead of adding the field to the child table. The lookup follows the parent record, so a vendor that changes tier moves its findings with it.
The bar chart of findings per tier from the Vendor Tier lookup: three bars, Tier 1, Tier 2 and Tier 3, with the legend at the right.
Permissions
Who can create a Chart view, change its settings and save them is the same for every chart. See Chart View for public and private views, autosave and locked views.
Using it in each place
Chart view: the dropdowns above, in the view's Chart Settings sidebar.
Chart widget: the same dropdowns in the widget's settings, after the solution and table are chosen.
Drill-in: select a bar, column, slice or point and the records behind it open in a drill-in window with its own toolbar and an Export button. See Edit records in a drill-in grid.
Frequently asked questions
Can I sum a lookup in a dashboard widget?
Can I sum a lookup in a dashboard widget?
A lookup of a numeric field is offered as a value with a function. The widget's dropdowns are the view's.
Can I group a chart by a lookup?
Can I group a chart by a lookup?
Yes. The Group By dropdown lists the lookup with its icon.
Can I open the records behind a segment?
Can I open the records behind a segment?
Yes. Select the segment and the records open in a drill-in window. See Edit records in a drill-in grid.
Why are some findings missing from the chart?
Why are some findings missing from the chart?
They have no linked vendor, so the lookup is empty and they are left out. Check Include empty values under Advanced Options to add them as their own bar or slice.
Last verified 30 Oct 2026.


