Skip to content
Type to search…

Build a widget: metrics, groupings, filters, and charts

A widget is one chart, table, or headline number on a dashboard. This article walks through building a widget in the widget builder, explains every control in it, and shows how to read the compatibility messages so you do not build a report that double counts.

A widget answers one question: a total, a trend, a ranking, or a breakdown. You build it in the widget builder by choosing what to measure, how to split it up, and how to show it. Dashboards are collections of widgets, so once you can build one widget you can build any dashboard.

  1. In Custom Reporting, select the + next to Mine to create a new dashboard. It starts as “Untitled dashboard”.
  2. Select the dashboard’s title and enter a name that describes what it is for, such as “Membership activity”.
  3. Select Add widget at the top right. The widget builder opens.
  4. Enter a title for the widget at the top of the builder, such as “Customers who purchased memberships”.

You can come back to rename a dashboard or edit any widget at any time.

The center of the builder offers Start from a template. A template fills in a complete widget that you can then adjust.

TemplateWhat it builds
Net salesA headline number compared with the previous period
Daily sales trendNet sales by business day, with the last period overlaid
Sales summaryGross sales, comps, net sales, tax, and tips
Tip %Tips divided by net sales, computed from totals
Sales by categoryShare of net sales across menu categories
Top productsBest sellers by net sales
Sales by hourNet sales by hour of day
Weekly sales by locationNet sales per week, stacked by location
Chart of accountsDebit, credit, and net from the ledger, by account type and account

Or skip the templates and build your own from the metrics list on the left. Everything stays editable either way.

The widget builder with templates in the center, metrics on the left, and settings on the right

The left side lists every metric you can measure, organized by the kind of data: Locations, Sales, Ledger, Item options, Sales by payment, Labor, and Tabs. Use Search metrics & fields to find one by name.

  • Point at a metric to read what it measures before you choose it. Metrics with similar names can measure different things, such as net sales and the amount posted to an account.
  • A green check next to a metric means it is certified: a standard, reviewed definition. See Check your numbers.
  • Select the checkbox to add a metric. Selected metrics appear in the Metrics section on the right. You can add several metrics to one widget.

Groupings decide how the metric is split up. Scroll the left side to the Group by section.

Group byExamples
SharedBusiness day, Hour of day
LocationsLocation, City, State or province
ServersServer (every user on the account appears here, not only servers)
ProductsProduct, Menu category, Product type (such as discounts, open items, and delivery fees)
ZonesZone, Zone type, Spot
Sales and ledgerAccount, Adjustment (comps, voids, refunds), Account type
Item optionsOption, and the adjustments on options
Sales by paymentPayment type or tender, Digital wallet, Paid at (POS, kiosk, customer, or integration), Card present, Payment source, Card last 4
LaborRole, Clock-in hour, Auto clocked out, Still clocked in
TabsTax exempt, Tax exemption ID, Tab, Tab name, Customer ID, Customer, Customer email, Tab status

Business day can be shown by day, week, month, quarter, year, or day of week.

Order matters. The first grouping you add becomes the main rows or axis. To change the order, remove the top grouping and add it again, and it moves to the bottom of the list.

The builder only lets you combine things that make sense together. When a grouping cannot be used with the metrics you picked, it moves into Not available with your selection and is grayed out. Point at it to read the reason.

A grouping that cannot be used shows the reason as a tooltip

For example, tax cannot be split by zone because it would be counted twice or credited to the wrong place. Because incompatible choices are blocked for you, you cannot accidentally build a broken report. If you need two things that do not work together, build two widgets.

On the right, pick how the result should look. The options you can use depend on how many metrics and groupings you have chosen.

VisualizationUse it for
NumberA single total, optionally compared with an earlier period
Line or AreaA trend over time
BarComparing categories. Can be stacked or side by side, vertical or horizontal
ComboA line and bars together, usually with one date grouping
DonutShare of a whole, with one grouping that is not a date
Treemap or HeatmapTwo groupings at once, such as hour by day of week
Table or PivotExact values, especially with several groupings or metrics

Scatter and Funnel also appear in the picker. Options that do not fit your current metrics and groupings are grayed out. Remove a grouping to see more options, or add one to unlock table-style views.

Increase is good controls the color of comparisons. Leave it on when a higher number is a good thing, like sales. Turn it off for numbers you want to go down, like comps or labor percentage.

The settings on the right are the same for every widget.

Bar chart settings including stacking, horizontal bars, legend, value labels, and axis titles

  • Chart options: For bar charts you can set the X and Y axis titles and turn Stacked, Horizontal bars, Legend, and Value labels on or off. The chart resizes as your browser window changes size.
  • Show metrics as: Choose Show totals, or Show average per day. With average per day, each value is divided by the number of days in the range. When you group by day of week, each weekday is divided by the number of that weekday in the range, so weekdays compare fairly even when your dates do not cover whole weeks. There are also options to work out each day, hour, or 15 minutes first and then add them up.
  • Filters: Narrow the data that goes into the widget, such as Menu category is any of Memberships. Date range and locations come from the dashboard, so you do not set them here.
  • Rows: Hide result rows that do not meet a condition, such as net sales over $1,000. Hidden rows still count in totals, so the visible rows may not add up to the total shown.
  • Compare: Show a reference period next to your results, such as the preceding period or the same weekdays last year.
  • Sort & limit: Choose how rows are ordered, by any metric or grouping and high to low or low to high. Enter a row limit to show only the top rows.
  • Inputs: Add a number that anyone viewing the dashboard can change, such as a tip-out rate. A formula can use it.
  • Formula: Calculate a new value from your metrics, such as tips divided by net sales.
  • Per-metric controls: Each metric has small buttons for Only where… (apply a condition to just that metric), % of total, and removing it.

Filters, rows, compare, and sort and limit settings

Filters narrow the underlying data before anything is added up. Rows only hides rows after the results are worked out. If the rows you can see do not add up to the total, check whether a Rows condition is hiding some.

A percentage calculated from the totals for the whole period can differ from the average of each day’s percentage. For example, $120 of tips on $1,000 of net sales is 12%, but that is a period-level ratio, not an average of daily ratios. Check how your widget is set to calculate, and compare it with a simple manual calculation for the same dates and locations.

Worked example: customers who bought memberships

Section titled “Worked example: customers who bought memberships”

This widget lists each customer who bought a membership in the date range, with the membership they bought.

  1. Select Add widget and enter the title Customers who purchased memberships.
  2. In the metrics list, check Quantity · Sales.
  3. Under Group by, add Customer, Customer email, and Product.

Customer, Customer email, and Product selected as groupings

  1. Under Filters, add Menu category is any of Memberships. Now only membership products are counted.
  2. Choose a visualization. With three groupings, Table or Pivot work. If you remove Customer email, a bar chart, treemap, or heatmap become available.
  3. Select Add to dashboard, then check the date range at the top of the dashboard.

Before you add a widget to a dashboard, check these three things:

  1. Open Show your work (bottom right of the preview) to read the metric definitions, the dates, and the locations the widget used.
  2. Confirm the dates. The builder shows a preview for the last 30 days (see the note at the top of the builder). Once the widget is saved, it follows the dates selected on the dashboard, so confirm those too.
  3. Check the badge. A Certified badge at the top of the builder means the widget uses certified metrics. See Check your numbers.

Then select Add to dashboard. To change a saved widget later, open the three-dot menu on the widget and choose Edit. Choose Duplicate first if you want to keep the original.

If you use an AI assistant such as Claude or ChatGPT, you can connect it to your dashboards and work in plain language. The assistant can look up your metrics, answer a question from your data, and help you build widgets and dashboards.

  1. In Claude, open Settings, then Connectors, and choose Add custom connector.
  2. Enter a name, for example “GoTab Dashboards”, and paste this address: https://dashboards.gotab.io/mcp
  3. Sign in with your GoTab login when Claude asks. GoTab confirms it is you with a code sent by text message. Approve access when prompted.
  4. Start a new chat and ask for what you need.

If you use a different assistant, add the same address as a custom connector there. The menu names differ from one assistant to the next.

Some examples to start with:

  • “Show net sales by menu category for last month across my locations, highest first.”
  • “Build a widget that compares tips by server for the last 7 days.”
  • “Which of my dashboards use labor cost?”
  • You see only your own locations. The connection uses your GoTab login, so your assistant can only reach the locations you already have access to.
  • Check the answer. An assistant can misread a request. Ask it which metric, dates, and locations it used. For anything you save, open the widget and use Show your work. See Check your numbers.
  • Your AI platform decides whether you can add a connector. Each platform sets its own rules for connectors on your account, so check its policies. GoTab Support cannot manage your account with another company.
  • Dashboards you build this way are saved in your account. Widgets and dashboards created through the connector appear in Mine, like any you build yourself.
  • Getting help. If you have trouble connecting, contact GoTab Support so we can make sure the connector is working. For help using the assistant itself, contact its provider.
  • Your results go to your assistant. The answers to your questions are shown in your chat, so follow your company’s policy on sharing business data with AI tools.

We are adding more metrics, groupings, and builder options over time, and some screens may be reorganized to make the builder easier to use. If there is a measure you need and cannot find, contact GoTab Support through the support chat. Ask for the metric to be added to Customer Reporting Dashboards, not the Data Hub dashboard, and describe the report you are building.