A matrix Workday report is a pivot-like tool used for groupings and summarizations, providing aggregated values similar to Excel. It is the foundation of advanced d-cube analytics in Workday, including composite reports.

Matrix workday reports are used for various scenarios, such as turnover rate, scorecards, headcount, termination trend, and higher trend workday analysis.

To create a matrix report, follow the same steps as creating a normal report, select a data source that is similar to the advanced report, such as All Active and Terminated Workers.

The layout of a matrix report differs from that of an advanced workday Report, with row grouping, column grouping, and summarization types.

A report that aims to analyse the data of insight global salary modern services companies by filtering and adding a filter company.

The report then presents various companies in rows, with a count for each company and a grouping parameter for gender, the report can be edited to include larger companies with larger populations, such as GMS Australia and ABC.

The report also shows the location of each employee in different countries, such as Sweden and UK, the data is then grouped into hyperlinks, which can be clicked on to display additional details like name, position, higher, job, and workday manager details.

However, the report only displays groupings and summarizations. To obtain detailed data, the user can use the “drill down” tab in the report.

The detailed data section in a matrix report allows users to add various fields, such as job profile, position, and workday supervisory organization.

However, the overall output remains the same due to no changes made on the matrix tab, the detailed data section also provides high-level summarizations, groupings, and metrics.