Skip to content
Admire Help

Dashboards

Dashboards let you build your own views of your data, bringing the numbers that matter into one place. Where a staff profile shows how one person is doing, a dashboard zooms out to the performance that surrounds them: how a team is tracking, how a role is progressing, or the statistics behind the workflows your people run. Those views are meant to feed coaching. The data gives a manager and their coachee something concrete to discuss, and turns a vague “how are things going” into a specific conversation about what to do next.

They work upward as well. A director and above can sit down with their managers around a shared dashboard and use it as the conversation point, so every layer of leadership is looking at the same picture of how its part of the organization is developing.

The Sales Dashboard combining a line chart of monthly revenue, a pie chart of revenue by region, a stat card of quarter-to-date figures, and a table of recent sales, with From and To date filters across the top.
A coaching dashboard pulls the metrics you care about into one view: the trend over time, how revenue breaks down, headline figures, and the latest detail.

Building a dashboard

Section titled “Building a dashboard”

Add widgets to a dashboard and arrange them with drag-and-drop. Each chart widget is driven by a query; you can also add markdown widgets for headings and context.

Widget types

Section titled “Widget types”

Admire picks the visualization automatically from the shape of your query’s result, so the way you write the query determines the chart:

  • Stat card: a single row of one to three numbers (e.g. a total).
A stat card widget showing three headline numbers side by side: Completed, In Progress, and Pending.
Stat card: headline numbers for the figures you check at a glance.
  • Line chart: a date column plus one or more numeric columns (a trend).
A line chart widget plotting an average score climbing month over month.
Line chart: how a metric moves over time.
  • Bar chart: one or more categories plus numeric values.
A bar chart widget comparing values across several categories.
Bar chart: compare a metric across teams, roles, or departments.
  • Pie chart: one category column plus one numeric column, over a handful of rows.
A pie chart widget showing how a total splits across a few categories.
Pie chart: how a total splits across a few categories.
  • Table: the fallback for anything else.
A table widget listing rows of data across several columns.
Table: the fallback for detail that doesn't reduce to a single chart.
  • Markdown: static rich text for headings and context (no query).

Because the display follows the result, shape the query to shape the chart: rename columns to set the axis and series labels, group to set the categories, and order rows the way you want them shown. You can also override the auto-detected type per widget when you want a specific chart.

Variables

Section titled “Variables”

Use dashboard variables to make a dashboard interactive, for example to filter by team or date range, so one dashboard answers many versions of the same question. Variables fill the :placeholders in each widget’s query.

Writing the queries

Section titled “Writing the queries”

You don’t need to be a SQL expert. Describe what you want in plain English and Admire drafts the query, or write SQL directly if you prefer. See Querying your data (SQL).