{"id":7540,"date":"2023-09-07T11:06:04","date_gmt":"2023-09-07T09:06:04","guid":{"rendered":"https:\/\/scapta.com\/?p=7540"},"modified":"2026-06-08T15:17:14","modified_gmt":"2026-06-08T13:17:14","slug":"analyze-data-in-bc","status":"publish","type":"post","link":"https:\/\/scapta.com\/en\/producten\/microsoft-dynamics-365-business-central\/analyseren-gegevens-in-bc\/","title":{"rendered":"Analyze your data in Business Central!"},"content":{"rendered":"

<\/p>\n\n\n\n

Would you like to analyze data from Business Central without running a report or switching to another application? The data analysis mode on list pages offers an interactive and versatile way to calculate, summarize, and explore data.<\/strong><\/em><\/p>\n\n\n\n

<\/p>\n\n\n\n

Required<\/h5>\n\n\n\n

The data analysis mode is currently in preview and must be enabled by an administrator. Administrators can do this by going to the \u2018Feature management\u2019 page and the feature \u2018Functionality Update: Analysis Mode, Analyze Data Directly in Business Central Quickly\u2019<\/strong> to activate. This feature will be available starting in Q4 2023.<\/p>\n\n\n\n

Action! <\/h5>\n\n\n\n

On a list page, for example customer entries, you can enable data analysis mode using the \u2018Analyze\u2019 function. Easily create an overview of open items per customer for a specific customer group. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
    \n
  1. In the pane Columns<\/strong> Define which columns should be included in the analysis, which fields you want to group by, and what total you want for fields containing numbers (e.g., sum, average, min, max, etc.) <\/li>\n<\/ol>\n\n\n\n
      \n
    1. In the Analysis filter <\/strong>Adjust your filters on the columns to narrow down the data in the list. For example: Remaining amount is greater than 0. <\/li>\n<\/ol>\n\n\n\n
        \n
      1. In the Data area<\/strong> The rows and columns of the list page are displayed, and the data is summarized. For some columns, subtotals will be visible. <\/li>\n<\/ol>\n\n\n\n
          \n
        1. In the Overview bar<\/strong> The statistics for the list are displayed. When you select multiple rows in a column containing amounts, the average, count, minimum, maximum, and sum are displayed for the selection. <\/li>\n<\/ol>\n\n\n\n
            \n
          1. If you want to perform multiple analyses on a list, you can multiple Tabs<\/strong> make. These tabs will remain until you remove them. Tabs that you set are only visible to yourself. <\/li>\n<\/ol>\n\n\n\n
              \n
            1. You can the Rotation mode<\/strong> activate to analyze a large amount of numerical data. This mode is similar to pivot tables in Microsoft Excel. <\/li>\n<\/ol>\n\n\n\n

              author: Riet Mondelaers<\/p>\n\n\n\n


              Do you have any further questions on this topic or are you interested in implementing Business Central in your company? Don't hesitate to contact us using the form below. We are ready to help you!<\/strong><\/em><\/p>\n\n\n\n

              <\/p>\n\n\n\n\n

              \n

              <\/p>

                <\/ul><\/div>\n
                \n
                \n<\/fieldset>\n
                \n\t

                <\/span><\/span>
                \n<\/span>
                \n<\/span>
                \n