Dan:

Per the developers:

1. Identify the Pivot Grid Model
·     Navigate to: Enterprise Components > Pivot Grid > Pivot Grid Models
·     Search for the Pivot Grid Model used in Absence Analytics (e.g., ABSENCE_ANALYTICS or similar, depending on your configuration).
·     Open the Pivot Grid Model.

2. Update Pivot Grid Data Source Settings
·     Under the Pivot Grid Wizard, go to Step 5: Pivot Grid Display.
·     Look for the "Maximum Rows to Return" field.
·     By default, it is set to 100. You can increase this to your desired number, e.g., 500 or 1000.
·     Save your changes.

3. Check Pivot Grid Viewer Settings
·     When running the analytics via the Pivot Grid Viewer, there’s an option at runtime to set how many rows to display (e.g., dropdown at the bottom of the grid).
·     Ensure users are aware they can adjust this in the viewer as well (up to the model's maximum)

4.   Performance Considerations
Increasing the row limit can impact performance.

• It's good practice to test the rendering time and server load if raising limits significantly (especially beyond 500 rows).
• Consider adding filters to narrow down data before fetching large volumes.