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
- Ask your AI, for example: “Make me a dashboard of this month’s sales, top customers this year and open orders.”
- The AI designs the layout from your company’s defined figures and describes it back to you in words.
- 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
| Tile | What 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 pie | A figure split by customer, item, salesperson, region or another field, showing the biggest. |
| Line | A figure month by month. It can draw last year alongside as a dashed line. |
| Matrix | A figure by rows and months, with row and column totals. Each row can open to the rows inside it, for example customers, then items. |
| Table | Records 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.