Warehouse data and dashboards

Make a dashboard

Turn what a chat found into a dashboard of charts, maps, numbers and text, with filters, live warehouse tiles and tiles that follow your data rules.

On this page

A dashboard is a board of tiles that answers one question for the people who read it. Make one in a chat from the charts, maps and figures the chat found, and share it like any other work. Dashboards are in Library.

When to use it

  • You asked a question in a chat and want to keep the answer where others can see it.
  • People check the same figures every week or every day.
  • The figures come from your warehouse, and each reader should see them as the warehouse gives them now.

For a screen with forms, sign-in or your own data model, build an app instead.

Make one from a chat

Ask in the chat once it has found what you want to keep.

Make a dashboard of this, with the monthly sales chart, the map of stores and the three headline figures.

Ahamo makes a new dashboard from the chat's charts and maps as they are, and adds the figures as number tiles. Only you can see it until you share it.

To add one chart or map, choose Pin to dashboard on it in the chat. Pick one of your dashboards, or New dashboard with a name, and choose Pin.

Tiles

TileWhat it shows
ChartA chart from the chat, or one drawn from a live warehouse query
MapA map from the chat, with its legend, or one drawn from a live query
NumberOne figure with its unit and how it was checked
TableRows from a dataset, at most 1,000
TextYour own words, such as what the board shows and where its data comes from

A dashboard holds at most 24 tiles. A number tile shows its figure as Ahamo worked it out and checked it, with its mark, such as Verified. See How figures are checked. The sources of the data are listed under the tiles, each with its credit and the time it was taken.

Change the layout

Choose Edit in the dashboard's header. Then:

  • drag a tile by its handle to move it, or drag its edges to resize it, in whole columns and rows;
  • open a tile's menu to rename it, move it, make it wider, narrower, taller or shorter, or remove it;
  • choose Add text for a text tile;
  • with the keyboard, Alt and the arrow keys move a tile, and Shift and the arrow keys resize it.

Choose Done when you're finished. Every change is saved, and you can undo it. On a phone, a tile's menu moves it up or down and sizes it.

You can also ask in the chat, for example to add a tile, put the map first, or remove a chart.

Filters

A dashboard can have filters that everyone who opens it can change for themselves:

  • a time range, such as Last 30 days, This year or Custom dates;
  • chips for the values of one field, such as country or team;
  • a threshold, a cut-off the reader sets.

Ask in the chat to add one. What a reader picks changes only their own view, and stays in the page's address, so a shared link keeps it. Defaults puts every filter back. On a phone, the filters are behind one Filters button.

A number tile is worked out for the default filters. While a filter it depends on is not at its default, it says Computed for the default filters. A tile a filter doesn't apply to says so, as in Not filtered by Region.

Live warehouse tiles

A chart, map or number can run a query on your warehouse each time someone opens the dashboard, instead of showing saved data. Ask for it in the chat.

Make the sales chart live, from Snowflake, so it is always current.

  • It runs as the person who opens the dashboard, on a connection that can only read. That person must be able to use the connection, so share the connection with the people the dashboard is for.
  • It shows Live and the time while the answer is fresh, or As of and a time when it shows a kept answer.
  • A live number shows as Not verified, because no check ran on it.
  • A chart draws at most 5,000 rows, a map 50,000.

A filter whose name the query uses changes the query for that reader.

To keep live tiles current without each reader waiting for the warehouse, set a refresh schedule.

Tiles under your data rules

On a connection with datasets, a chart, number or table asks a dataset instead of running SQL. Each reader sees it under their own access:

  • the rows their rule lets through, and masked columns marked Masked for you;
  • with totals only, groups of fewer than 5 rows left out, marked Groups under 5 left out;
  • with no access, You don't have access to this data. Whoever manages it can share it with you.

These tiles are never kept, because each reader sees different rows.

Share a dashboard

Share a dashboard as you share other work in Ahamo. Everyone you share it with sees its saved data. Live and dataset tiles still run as each reader, with the reader's own access. See Share an app.

Troubleshooting

This connection can change data, so a dashboard doesn't run it. The tile's connection may change data. Its owner can connect it again as Only read.

You can't use this tile's connection. Ask its owner to share it with you. The tile runs as you, on a connection you may not use.

This connection's data has rules, so this query can't run on it. The connection has datasets. Ask Ahamo to make the tile ask a dataset instead.

The query would cost more than the limit, so it didn't run. Ask Ahamo to narrow the query, with fewer columns or a shorter period.

The query took too long and was stopped. Ask Ahamo to total the rows in the warehouse, or to narrow the query.

The query returns more than one row, so there's no single number. A number tile's query must return one row. Ask Ahamo to fix it.

This dashboard changed while you were editing, so your last change wasn't saved. Someone else changed it at the same time. You now see the latest version. Make your change again.

On this page