AI Assistant docs

Live dashboards

Ask your AI for a dashboard in your own words. Business Central works out every figure live, each time it is opened, as the person looking at it.

Make a dashboard by asking

  1. Ask your AI, for example: “Make me a dashboard of this month’s sales, top customers this year and open orders.”
  2. The AI designs the layout from your company’s defined figures and describes it back to you in words.
  3. Say yes to save it. The AI gives you a link that opens it in Business Central.

The AI only designs the layout: which tiles, which figure and which period. It never supplies a figure. Every figure comes from Business Central, with your own permissions, data areas, table and field rules and data scope. A figure you may not see shows the reason instead.

To change a dashboard, ask: “Add a tile for overdue invoices” or “Show the top 10 customers instead”. To remove one, ask the AI to remove it.

Ready-made dashboards

Search for AI Dashboards and choose Ready-made dashboard to make one in one click for sales, finance, buying, stock or the whole business, or Sales analysis. It is yours: ask your AI to change any tile. Dashboards for a customer, vendor or item are also available.

Kinds of tile

TileWhat it shows
Figure (KPI)One figure for a period, compared with the previous period or last year. It can show a target as a progress bar and the % of target.
Bar and pieA figure split by customer, item, salesperson, region or another field, showing the biggest.
LineA figure month by month. It can draw last year alongside as a dashed line.
MatrixA figure by rows and months, with row and column totals. Each row can open to the rows inside it, for example customers, then items.
TableRecords from a Business Central table, such as open sales orders, with the columns you choose.

A dashboard holds up to 12 tiles.

Use a dashboard

  • Open the records behind a figure: select a bar, slice, point, cell or total to see the records behind it.
  • Filters: filter by customer, vendor, item, item category, customer group, salesperson, location or dimension. Type a value or pick from the list. A tile that can’t be filtered that way says so.
  • Period: today, this month, last month, this quarter, year to date, last 12 months, or your own dates, for the whole dashboard.
  • Measures: where a tile offers more than one measure, such as sales, margin and margin %, switch between them.
  • Look: automatic, light or dark.
  • Export to Excel: a sheet per tile, with the figures as you see them, your filters, period and measures included.
  • Refresh: works the figures out again now. A dashboard can also refresh itself every few minutes.

Your filters, period, measures and look are remembered for you on each dashboard.

Why did it change?

On a figure with a comparison, choose Why did it change?. It splits the change by customer, item, salesperson, location and dimensions, and shows the groups that moved most, worked out with your permissions.

Data checks

A dashboard warns you when a figure may mislead, for example when 1% or more of it has the grouping field blank, or when entries are dated after today.

Put a dashboard where you work

  • Role Centre: use Personalise to add the Bee Solved dashboard part, then choose the dashboard to show.
  • Customer, vendor and item cards: a dashboard about a customer, vendor or item shows in the FactBox on that card, filtered to that record.

Who can do what

  • Anyone with the AI Assistant switched on can make dashboards of their own.
  • Only the owner changes a dashboard. The owner or an administrator removes it.
  • Only an administrator shares a dashboard with everyone. Everyone then sees only the figures their own permissions allow.

Good to know: year to date means the calendar year. For several values in one filter, type them with | between them.

See also Answers and exports and Teach it your business, where you define the figures a dashboard uses.