Demo practice questions for guest users.
When reports use Indexed Data Sources, performance issues can arise if sorting is attempted on
fields that are not indexed. In the case of the Worker object, sorting directly by the Worker object
field is slower. Workday best practice is to sort by text-based fields such as the “Full Name (text)”
field, which improves query performance because it leverages indexed fields.
From the Workday reporting materials:
*“For indexed data sources, performance improves when sorting by text fields such as Full Name
(text), instead of object fields. Sorting by object fields causes slower performance, whereas text-
based fields use the
Matrix reports in Workday allow grouping of data, applying summarizations, and drilling into the
summaries for deeper analysis . To calculate percentages relative to the overall total, Workday
provides a built-in summarization option called “Percent of Overall Total.” This option is applied to
numeric summarizations like “Number of Hires.”
From the Workday Reporting Guide:
“Matrix reports allow you to group data, summarize the metrics for each grouping, and drill into the
summarizations for further analysis.”
“You can apply different summarizations such as Count, Sum, Average, and Percent of Overall Total
on numeric fields.” (Matrix Report Options – Workday Module 1 Binder)
Therefore, to show the percentage of hires per recruiter relative to the grand total across recruiters
and regions, you would select “Percent of Overall Total” on the Number of Hires summarization.