Dashboards

Dashboards let you build your own views of your data — going beyond the built-in reports when you have a specific question to answer.

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

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).
• Line chart — a date column plus one or more numeric columns (a trend).
• Pie chart — one category column plus one numeric column, over a handful of rows.
• Bar chart — one or more categories plus numeric values.
• Table — the fallback for anything else.
• 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

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

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).