Your first chart — argument, value, and the visualization builder
A chart turns a summarized report into a picture. The hard part isn't the buttons — it's seeing your data the way a chart needs to see it: one category per bar, one number per category. Get that idea and the visualization builder becomes obvious. This lesson keeps the data simple so the builder is the only new thing; the next lesson handles the reshaping.
By the end of this lesson
- Name the two roles every chart needs — the argument (category) and the value series (number) — and recognize chart-ready data on sight
- Build, tune, and save a first chart from a summarized report in the visualization builder
- Know which knobs live in Chart Options versus Display Options, and when the preview is lying to you
You'll need
- A summarized report — a count, sum, or average grouped by a category. See Dataset prep and Report formulas if aggregating is new
- Composer role on the app, and a report open in the Composer — see Your first report
Background
Most charting trouble isn't about the software. It's that a chart asks you to organize your data in a particular way, and nobody ever spells out what that way is. So before any clicking, two words and one rule.
Every chart in DashboardFox — line, bar, column, pie, and the rest — is built from the same two roles:
- The argument is the category you're grouping by. It becomes the x-axis, and it's almost always a label — a
customer, astatus, amonth. The argument answers "one bar (or point, or slice) for each of what?" - The value series is the number you plot against each category. It becomes the y-axis, and it's an aggregated number — a count of tickets, a sum of revenue, an average response time. The value series is the height of the bar.
The rule underneath both of them: one row per argument. The chart wants exactly one row for each category — one row for "Honeywell Honey," one for "EverGlade Gardens," and so on. If a customer turns up on three rows, you get three bars where you wanted one. Getting your report into that shape — one clean row per category, with the number already aggregated — is most of the real work of charting, and it's the whole subject of the next lesson. Here, we keep the data already in that shape so you can learn the builder by itself.
The visualization builder, at a glance
Once your report is summarized, the Visualizations button opens the builder. It has three parts you'll use every time:
- Select Visualization — pick the chart type from the palette. You can switch types anytime without starting over.
- Argument Field and Add New — the builder defaults your first text field as the argument; Add New is where you attach each value series.
- The accordions — Chart Options (settings global to the chart: axis labels, legend, title position) and Display Options (settings specific to the chart type: spline, data points, constant line). They're collapsed by default, which is the builder telling you the defaults are usually fine — open one only when you want to change something.
Where this sits in Module 8
The visualization types, at a glance
The palette has nineteen options. The good news for a beginner: eight of them are charts that share one builder and one set of rules — the ones this lesson and the next are about. The other eleven are specialized visualizations, each with its own data shape and its own builder, covered in their own lessons later in Module 8.
Stuck before you've even built a report to chart? Email [email protected] and tell us what app you're working in. Real human, same business day reply.
Do it
-
Build a summarized report
Start in the Composer with a single category and a single count. Pick the
Ticketsapp and category, add ticket number to Selected Data, and add customer. On the ticket-number card, add a formula and set it to Aggregate → Count — the card now readsCOUNT(?).The preview collapses to one row per customer with a count beside it. That collapse is the important part: the aggregate is what turns "many ticket rows" into "one row per customer," which is exactly the one-row-per-argument shape a chart needs. You're not charting yet, but the data is now chartable.
-
Open the builder and pick a chart
Click Visualizations in the toolbar. The Visualisation of Data panel opens with the type palette. Click Line Chart to start.
Two things happen automatically. The builder fills the Argument Field with the first text field it finds — here,
customer— because the argument is almost always a label. And the preview waits, telling you to define the value series before it can draw anything. -
Add the value series
Click Add New, then choose your count under Value Field. The moment you pick it, the preview draws your line. That's the whole core of charting: one argument, one value series.
Two optional accordions sit under the value field, both closed by default:
- Values Options — Label Formats (display the number as
currency,largeNumber, orpercentinstead of a plainfixedPoint) and Precision (how many decimals). - Color Options — Select Bar Color, by swatch or hex, for this series.
You can accept the defaults and just click Save on the series. The full list of every option is in the chart options reference.
- Values Options — Label Formats (display the number as
-
Name it, then try other chart types
Type a Chart Title —
Tickets by Customer. (If this chart will live on a dashboard you may prefer the widget's title instead, but a title on the chart itself never hurts.)Now switch types to see which one fits. Back in Select Visualization, try Bar, Column, Pie, Area. With a single value series, Stacked Column looks identical to a column — stacking only earns its keep once you have multiple series, which is the next lesson. The point of switching freely is that the chart type is a display choice; the data underneath doesn't change.
-
Tune with Chart Options and Display Options
Two accordions hold the rest of the controls, and the split is worth learning because it tells you where to look.
Chart Options is global to the chart:
- Argument Axis and Value Axis — the labels printed along each axis (e.g. "Customer" and "Ticket count"). This is what "adding labels" means here: naming the axes.
- Title Position — top or bottom, left/center/right.
- Legend Position — left, right, top, bottom, or None to turn it off. On a single-series chart the legend often adds nothing; None is the off switch.
- Tick Interval — spacing of the value-axis ticks;
0means auto.
Display Options is specific to the chart type, so this list grows and shrinks as you switch:
- Show value on hover — the tooltip with the exact number.
- Chart Area Human Readable Labels — prints the value right on each point or bar, so you don't have to hover or read it against the axis. Lovely with a few categories; noisy with many. If you turn it on, you'll usually want hover off.
- Constant Line — a static threshold line, e.g. a goal of
2000. - Disable Line Chart Points / Display as Spline — line- and area-specific touches (hide the dots; curve the line). These only appear for those types.
-
Save, and re-open with Config
Click Save & Apply. Your report now renders as the chart.
To come back and edit, look next to Visualizations for Config. The distinction matters: Config reopens the builder with everything you set still in place, while clicking Visualization again starts you over from the palette. When you just want to tweak a color or a label, use Config.
You have a working connection. Below is what to tighten before real users see it. Skip if you're just testing.
Make it real
The builder is easy. These are the four things that trip people up after the builder — the difference between a chart that looks right and one that is right.
Sort lives on the report, not the chart
There's no "sort" control in the chart builder, and people hunt for one. The chart simply follows the order of the underlying report. To order the bars by size, put a sort on the value column (descending for biggest-first). To put the categories in alphabetical order instead, sort the argument column. Change the report's sort, and the chart re-orders to match.
The preview is a top-50 sample — verify with View Full Document
The preview panel only renders the top 50 rows. That's a safety cap so the builder never tries to pull your whole table while you're still clicking. But it means the preview can mislead you: a chart that looks tidy at 50 rows might be 133 customers wide in reality. Before you trust the shape, Reset the Grid to drop back to the report, then View Full Document to see every row. What you see there is the real chart.
Tame a busy chart with Top N
A hundred-plus categories on an axis is unreadable — and because the chart renders responsively, a cramped widget will quietly hide labels to fit, which looks like a bug but isn't. The fix is to limit the rows: add a sort, then a Top N from the Data Prep dropdown. Top 20 or Top 25 is the practical readability ceiling for a column chart. Data Prep tools covers Top N in full, including why it always rides alongside a sort.
Pick the chart that matches the question
The type isn't decoration. A trend over time wants a line or area. Comparing categories wants a bar or column — bar when the labels are long. One category's share of a whole wants a pie, and only when there are a few slices. If you can't tell what a chart is saying in a second, the type is usually wrong before the data is.
If you're stuck
The first-chart stumbles, in roughly the order they show up. Most mean your data isn't in chart shape yet, not that anything's broken.
The Argument Field dropdown is empty, or only shows numbers
The builder fills the argument with text fields, so an empty dropdown means your report has no character field to group by. If your category really is a number — a day-of-week number, a month number — you can use it, but you have to opt in: open Chart Options and check Allow Numeric Argument Fields. We keep that off by default so the dropdown isn't cluttered with every numeric column when, ninety-five percent of the time, the argument is a label. Chart data shaping walks through the numeric-argument case.
My chart has far more bars than I expected, and labels are cut off
That's the full row count showing up — the preview's top-50 sample was hiding it. A hundred categories won't fit, and the responsive layout drops labels to cope. Add a sort and a Top N (try Top 20) so the chart shows a readable slice. This is covered in Data Prep tools.
I clicked Visualization and lost my whole setup
Visualization reopens the type palette and starts a fresh chart; Config reopens the chart you already built. Once a chart is configured, use Config to make changes. If you started over by accident, your saved version is still intact — re-open the report from the library and it reloads as you last saved it.
The preview looked fine but the saved chart looks different
Same root cause as the extra bars: the preview is a 50-row sample, and the saved chart runs against everything. Always confirm with View Full Document before you save and share. If the full document is genuinely too heavy to render, that's a signal to add criteria or a Top N, not to trust the sample.
My chart is a tangle of overlapping bars or lines
You probably left extra columns turned on in the report. Every visible field is part of the row's identity, so an extra column means several rows per category instead of one — and the chart faithfully draws all of them. You need one row per argument. Reshaping the report to get there — aggregating, hiding fields you only want for filters, pivoting — is the whole of the next lesson.
The legend just repeats the obvious
On a single-series chart the legend often says nothing the title doesn't. Open Chart Options and set Legend Position to None. It comes back into its own once you're plotting multiple series.
None of these match my situation
Email [email protected] with the app, the report, and a screenshot of what you're seeing. Real human, same business day reply.
