Interface Designer: Report on metrics with the dashboard layout

Dashboards are a lifesaver when it comes to viewing essential info in one fell swoop, and Interface Designer’s dashboard layout is perfect when you want to aggregate information, highlight trends, or visualize distribution in charts and graphs. 

Dashboards are ideal for showing executive teams detailed information on what’s going on at the company so they can make informed decisions. Maybe you need a sales dashboard highlighting accounts in each stage with revenue projections, or a topline goals dashboard that shows progress across company-wide initiatives. Whatever the need, if the data is in your base, you can build an impressive custom dashboard in minutes. 

In this guide, we’ll be harnessing the dashboard layout to create a roadmap so our product team can track their quarterly goals—and the rest of the org can stay up-to-date on the development and launch schedule.

Ready to save your team some time and headaches? 

Getting started

Creating an interface starts with choosing a base, and knowing the problem you’re trying to solve. Try asking yourself who your audience is and what information they need to view.

We want to build a dashboard to highlight major feature launches for our executive team in this guide, but keep in mind that the following steps can be applied to any dashboard use case.

Go ahead and click the “interface” button on the top left of your base to start building.

Naming & description

Don’t skip over the name! Taking the time to give your group of interfaces a name and description helps your collaborators understand how they should engage with it. 

In this example, we’ll assign the main title “Product Roadmap” and describe it as “Source of truth for upcoming launches and A/B tests.”

Select dashboard layout & connect a table

Every time you create an interface, you’ll be asked to select a layout. Select the dashboard layout, then select the table holding the information you want to display. We’re going to connect our dashboard layout to our “features” table, as it has most of the information we need to report on the status and timing of upcoming feature development.

Choosing the dashboard layout lets you jumpstart your interface with a simple toggle to add or remove summaries, charts, and graphs. If you see elements from your table that you don’t need, you can simply toggle them off. And if you change your mind? Don’t worry—you can add these back in once you dive into editing.

⚡ Pro tip: With the dashboard layout, you can pull information from other tables in editing mode. For instance, if you’d like to have a number element display a metric from outside of the “features” table we’ve chosen.

Customize your elements

The dashboard layout is meant to highlight key information, so definitely utilize Interface Designer’s most visual elements. Before going into editing mode, you can toggle a few elements that have been automatically connected to your table.

Number

For our product roadmap, we’re going to use the number element to keep the highest level metrics—the numbers the org cares most about—front and center.

When you select the number element, filter the release date field to “after yesterday,” meaning any day in the future, and select the summary type “earliest date.” When you add a date to be summarized in a number element, you’re given options for how you want to represent the data. You can summarize by the earliest or latest date, or by the number of months or days.

Let’s add two more number elements: one for the number of large features we’ve shipped this quarter, and another for any features at risk for our next release. You can add additional numbers depending on what’s present in your base, or you can remove some if three is too many.

Chart

Next, we’ll add a chart to highlight NPS scores over time to understand the relationship between feature launches and customer satisfaction. To set up a chart, you can add any necessary filterings, then select your X and Y-axis. Since we want to show our NPS score over time as it relates to the roadmap, the X-axis will be our dates and the Y-axis will be the average NPS score. We’ll name it “NPS Score over time” and keep the auto-generated labels for the X & Y axes.

You’re not limited to the elements that have been pre-selected for you, so feel free to add and remove them as you see fit after you’ve given your interface a name and description. The following are some elements you can add once you enter editing mode.

Timeline view

Let’s add the Timeline view element—this is a roadmap, after all! 

Timeline view will show all of the features that are launching on a neat timeline, making it easier for cross-functional teams to know what’s shipping when. 

⚡ Pro tip: Have a lot of info to display on the timeline? Consider giving your collaborators the ability to filter the information themselves. This option is available on all data-rich elements, from timelines to grids and charts. Choose the field that is most helpful to filter by—we’ll filter by the product area so the cross-functional teams can more easily find the dates they’re looking for. 

Grid View

Grid view elements are ideal for scenarios where you want to display specific information from a table in your base. We’re going to add a grid view of prioritized customer feedback to further enrich the product roadmap and provide context on our priorities.

Incorporate design

Have you selected all the elements and fields you want to display in your interface? Great! Now, it’s time to add some design so your team can easily navigate the dashboard you’ve built.

We have a few design recommendations you can take or leave, like:

  • Add text elements to create headers (this can give your information context)

  • Keep your numbers together 

  • Incorporate color to help break out information—we’ll add some color behind the customer feedback section

No matter which layout you’ve chosen, don’t add so many elements that your interface turns into one endless scroll of information. Feel free to move blocks around to cut down on all that space, too. You can always create multiple dashboards for different roadmaps if your single dashboard is getting too long.

Preview & publish

Make sure your filters work by previewing your interface first. You can toggle the preview in the upper-left corner of the interface, which will let you test your editable elements and fields and view them as a collaborator.

When you’re happy with your interface, click the publish button. Congratulations! Your interface is ready to be shared 👏

Click the share button to invite individuals via email, or copy and paste the link if your team already has access to the base. Your organization now has a fleshed-out product roadmap they can quickly consult for goal and shipping updates.

Next up in Airtable for Collaborate With Your Team

5 of 7

7 of 7

Explore the latest in Guides

3 Guides

Quickly get data from anyone, anywhere into Airtable

The more data you have, the more you can do. Learn how to easily add additional data to your base

5 Guides

Why Airtable?

If you’re wondering how or even if your team should use Airtable, what makes it different from a spreadsheet, or what a “low-code platform” means, then this guide is for you.

Browse all in Airtable Guides

Join us and change how you work.