M‑Files dashboards for the week ahead

CtrlPortals adds dashboards to M‑Files: tiles, charts, gauges and lists drawn from the objects in your vault, with figures from other systems beside them. Every figure opens the objects it counts. Any M‑Files edition, in M‑Files Cloud or on-premise.

A CtrlPortals dashboard called Contract deadlines. A red tile counts four notices due in the next 30 days, a green tile counts nine contracts signed this quarter, up 50% on the same days of the quarter before, and a stacked bar chart shows how many customer, supplier, service and NDA contracts end in each month of the coming year.

Monday's questions, answered on one screen

Contracts, reviews, tasks and deals already carry their dates, owners and workflow states in M‑Files. A dashboard counts them where they are, so the week's figures are waiting when you open M‑Files, with no export to Excel or a BI tool in between.

A tile for the number that matters

One number in large type on a card in your colour: notices due this month, documents waiting for approval, actions past their date.

This month against the last

A tile can count the week, month or quarter so far and compare it with the period before or the same one last year, to the same day. The change shows green for good news and red for bad.

Bars and pies that compare

Bars set departments, months or types side by side, and stacked bars show what each total is made of. A pie or a donut shows how a whole divides.

Lines that show the trend

A line follows a figure week by week. Lay this year over last year, month by month, in one graph and you see at once whether this spring is busier than the last.

A gauge against the target

A gauge sets a figure on a scale with its target and bands such as behind, at risk and on track, and takes the colour of the band it lands in.

A list of what is due

A list shows the objects themselves, with deadlines that turn orange as they near and red once passed, and the people on each shown by picture or initials.

A Document control dashboard, dimmed behind a list titled Details for Production in Draft that opened from the Draft part of the Production bar in its chart of documents in progress by department. The list shows six documents, among them a calibration schedule, a forklift pre-use check and a line clearance procedure, with their document type and owner.

Ask any figure where it came from

When a number looks wrong, the next question is which objects are behind it. Click a bar, a slice or a tile and they open in a list over the dashboard.

  • The object, with its portal — Pick an object in the list and M‑Files selects it, so its portal and metadata card appear beside the dashboard.
  • Charts that narrow one another — When the charts and lists of a dashboard work together, a click on a month or a customer narrows all the others to match. Clicks add up into one filter, and what falls outside it fades.
  • The list in Excel as it stands — The objects behind a figure, or whatever a filtered dashboard still shows, land in an Excel workbook, with dates that sort and filter.

See your own Monday figures on a dashboard

A dashboard for each team's figures

Each team gets a dashboard of its own, built around your objects, fields and wording.

A Document control dashboard: tiles counting six documents awaiting approval, eleven reviews due this month and three overdue tasks, above a stacked bar chart of documents in progress by department, split into draft, in review and awaiting approval.

See where documents are waiting

A quality manager opens the week with the documents awaiting approval, the reviews due this month and the tasks past their date. Bars by department show where drafts pile up, and each part of a bar opens the documents in it.

A Project portfolio dashboard: tiles counting five active projects, four tasks past their end date and 38 tasks completed from 1 to 22 September, up 22.6% on the same days of August, above a bar chart of how far each of the five projects has come.

Every project's progress on one screen

A head of projects sees how far each project has come, the tasks past their end date and the tasks completed this month against the same days last month. The late tasks are one click away, on their tile.

A Sales overview dashboard: tiles counting nine active customers, a pipeline value of €494,000 and one deal closed this month, above a bar chart of opportunities by state, from lead to closed as lost.

Where the pipeline stands this month

A sales lead sees the active customers, the value of the pipeline and the deals closed this month, with the opportunities by state below. Invoiced figures from the ERP can sit on the same dashboard, read from Microsoft SQL Server.

Figures from the ERP, beside the vault's own

Some figures sit outside M‑Files, such as invoiced revenue in the ERP. When they are in a Microsoft SQL Server database, a chart reads them there and stands on the dashboard beside the charts of your objects.

  • Both sources in one chart — One chart can show SQL figures and M‑Files figures together, along the same weeks or months.
  • Daily rows, read as a trend — Rows from SQL Server can be gathered into weeks, months or quarters, so a long run of daily figures reads as a line you can follow.
  • Back to the rows behind a figure — A figure from SQL Server opens the rows it came from, just as a figure from the vault opens its objects.

Opened where people already look

Built in M‑Files Admin

Your administrator sets up each dashboard in M‑Files Admin and decides what it shows and in what order.

For the people who need it

Dashboards are grouped in the M‑Files menu, and a group can be kept for one user group, such as the management team.

From the menu, a view or the home screen

A dashboard opens from the M‑Files menu on the left. It can also be opened from a view, or replace the M‑Files home screen for everyone.

One project's figures on its portal

The same charts can sit on an object's portal and count only that project's or customer's figures, with a gauge measured against its own budget.

What it needs to run

  • Any M‑Files edition, in M‑Files Cloud or on-premise, with M‑Files 25.1 or later on the server and in the clients.
  • M‑Files licences for the people using it, and CtrlPortals, which the dashboards are part of.
  • The new or the classic M‑Files desktop client, or M‑Files Web.
  • For figures from the vault, nothing more: no M‑Files Reporting Server and no separate database. Microsoft SQL Server for figures from other systems, when you want them.

The settings for dashboards, charts and their data are in the CtrlPortals documentation.

Tell us which figures you rebuild every week

Name the counts and charts someone puts together in Excel today, and we'll show you how they look on a dashboard in M‑Files.

Questions about dashboards in M‑Files

Which charts and graphs can a dashboard show?
Tiles with a single figure, bar charts grouped or stacked, line and scatter charts, pies and donuts, and gauges, next to lists of the objects themselves. A chart can mix tiles with a graph, and a bar, line or scatter chart can put several years side by side.
How is it different from a BI tool?
The dashboards sit inside M‑Files and read the vault and SQL Server directly. Their charts can narrow one another as you click, as in a BI tool, and every figure keeps its way back to the objects or SQL rows it was counted from, which an export to a BI tool leaves behind. The longer read is data visualisation in M‑Files.
Do we need M‑Files Reporting or an external database?
No. Charts of vault data read M‑Files directly, with no M‑Files Reporting Server and no separate database. Microsoft SQL Server comes in only for figures from another system or for charts over a large dataset.
Can figures from SQL Server or an ERP be shown?
Yes, from Microsoft SQL Server. A chart can read an SQL Server database, such as one that holds the ERP's figures, and stand beside the charts of vault data. One chart can show both along the same dates, and its SQL figures open the rows behind them.
Can a dashboard be exported?
Yes, to Excel. The figures behind a chart go to a workbook with their labels and legends. Once a few clicks have narrowed a dashboard, its export holds only what is left, one sheet per set of data, and dates arrive as real Excel dates. More in exporting M‑Files to Excel.
Is it a separate product?
No. Dashboards come with CtrlPortals, which also brings portals, forms, kanban boards, gantt charts, lists and calendars to M‑Files. It is licensed per normalised M‑Files user, with a 30-day trial. Tell us how many people would read the dashboards, and you will hear back the same working day.