Analyze, group, and pivot data on lists

Important

This content is archived and is not being updated. For the latest documentation, go to What's new or changed in Business Central. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.

Enabled for Public preview General availability
Users by admins, makers, or analysts - Oct 2, 2023

Business value

End users and data analysts can analyze data from lists directly in the client without the need to open the page in Excel or run a report.

The ability to analyze data directly in lists raises the bar for what you can do without having to switch applications, while still allowing customers and partners to do more in report objects, Excel, Power BI, or other data analysis applications.

Feature details

Analysis mode is a new way of interacting with data on lists. Instead of running reports using different options and filters, you can simply add multiple tabs that represent different tasks or views on the data. Examples could be "My customers," "Follow-up items," "Recently added vendors," "Sales statistics," or any other view you want.

When you're ready to analyze data on a list page (where you might have filtered data using a view or filter pane), simply switch to analysis mode:

Shows how to enable analysis mode on list pages.

Analysis mode opens the data in a new experience that's optimized for data analysis. When a page is in analysis mode, it's split into two areas:

  • The main data area (including a Tabs pane)
  • The field modifier area

Explains the parts that are available in analysis mode.

Use the data area to interact with the data. For columns that are summable, you can easily get descriptive statistics on a set of fields by marking them.

Shows the cell statistics.

The bottom of the data area shows the total row count on the column.

Shows the row count in analysis mode.

Use the field modifier area to control the data to show and its format. On the menu, you choose the fields to show or hide.

Shows the Field Modifier area in analysis mode.

You can group data by dragging fields to the Grouping part of the Columns menu. This lets you explore data grouped by one or more fields to the left of the data area.

Shows row groups in the Field Modifier area in analysis mode.

Grouping works great in pivot mode. To enable pivot mode, turn on the Pivot Mode toggle switch and then drag fields that are to be summed to the Values part.

Shows pivot row groups in analysis mode.

In pivot mode, you can define groups that show up in the column part of the data area. Do this by dragging fields to the Column Labels part of the Columns menu.

Shows pivot row and column groups in analysis mode.

Column grouping works best if the grouping field only contains a few values.

Use the Additional Filters menu of the field modifier area to apply more filters to the dataset. In this part of an analysis, you might want to focus on a specific customer or period of time.

Shows additional filter options in analysis mode.

The data area gives you rich control of the layout of columns.

  • Drag columns to where they make the most sense in your analysis.
  • Pin a column to the left or right side of the column part.
  • Define data filters directly on the column definition instead of going to the field modifier area. You can still peek in on details about related data and for each line, and open the card to learn more about a given entity.

Business Central can save multiple column setups and filters. The next time you switch to analysis mode you can dive straight in to analyzing data. On the Tabs pane, you can rename or remove a tab.

Shows the Rename tab in analysis mode.

The Tabs pane also lets you add new tabs.

Shows the New tab in analysis mode.

Using tabs allows you to save different setups that you frequently use to analyze a dataset. For example, you might have tabs for analyzing data with pivot mode, and other tabs that filter to a subset of rows. Some tabs might show a detailed view with many columns, and others only display a few key columns.

Note

These tabs are saved for your use only.

How much data can I analyze?

On a list page, as a starting point you can set filters to limit the data. Maybe you want to analyze a certain group of customers, or maybe you want data from the current year only. You can also choose a page view to perform this action. You don't have to do this prefiltering step, but going to analysis mode will load all data into your browser, so it might be needed for larger datasets (currently above 100,000 rows).

In the 2023 release wave 2, we allow users to analyze more data than 100,000 rows.

How do I get started with analysis mode?

The feature is turned on by default. Your administrator can turn it off using the Feature Management page by disabling Analysis mode.

Shows how to enable analysis mode on the Feature Management page.

What we changed based on feedback from the public preview

  • Added the ability to control on which list pages the analysis mode is enabled.
  • Added the ability to share an analysis mode tab with a co-worker.
  • Increased the data set size to above 100,000 rows.
  • Added persistence for the user's choice of analysis mode on list pages, so that their preferences are remembered from their last visit.

As a Business Central partner, you can give feedback on the feature in this Yammer group: https://www.yammer.com/dynamicsnavdev/#/threads/inGroup?type=in_group&feedId=119944077312&view=all

See also

Analyze list page and query data using data analysis mode (docs)