Multi-Section Sheets and Multi-Axis Sheets
JustPerform offers advanced sheet capabilities that enable sophisticated data presentation and reporting through multi-section sheets and multi-axis sheets. These features allow you to create complex data structures within a single sheet while maintaining clarity and organization.
Multi-Section Sheets
Multi-section sheets allow you to create multiple sections within a single sheet, with each section having a different level of detail. This capability enables you to utilize multiple sets of fields in the same sheet, making it ideal for sophisticated reporting scenarios.
Key Features
- Each section can have varied levels of detail
- Enables more sophisticated and comprehensive reporting
- Functionality extends to both input snippets and report snippets
- Sections can share axes for coordinated data presentation
How to Create Multi-Section Sheets
Follow these steps to enable and configure multi-section sheets:
- Navigate to the Fields pane of Sheet Detail
- Check the option Allow Multiple Sections
- Add sections to the sheet as needed
- Add or remove fields from each respective section
- Configure sections to share axes if desired (see Multi-Axis Sheets below)
Multi-Axis Sheets
Multi-axis sheets provide the ability to add multiple row or column axes to your sheet. This is controlled through the Layout Type setting in the Sheet Detail section.
Layout Types
JustPerform offers different layout types that determine how fields and axes are structured:
| Layout Type | Description |
|---|---|
| Standard | Fields can be arranged in rows, columns, and filters using traditional layout |
| Shared Row Axis | Allows you to add multiple row axes to the sheet from the same or different sections |
| Shared Column Axis | Allows you to add multiple column axes to the sheet from the same or different sections |
How Multi-Axis Sheets Work
The appearance of the sheet layout is determined by the Layout Type selection:
- Standard Layout: Fields can be arranged in rows, columns, and filters in the traditional manner
- Shared Axis Layouts: When you change the layout type to Shared Row Axis or Shared Column Axis, you can add multiple row or column axes to the sheet
- Axes can come from the same section or from different sections of the sheet
- This provides flexibility in how data is organized and presented
Configuring Layout Type
To configure the layout type for your sheet:
- Open the Sheet Detail section
- Navigate to the Layout section
- Select your desired Layout Type from the available options
- Configure your row and column axes as needed
Use Cases and Benefits
The combination of multi-section sheets and multi-axis sheets enables powerful reporting scenarios:
- Consolidated Reporting: Present data at different levels of detail within a single sheet
- Complex Analysis: Combine multiple dimensions and metrics in coordinated views
- Flexible Presentation: Adapt the layout to match your specific reporting requirements
- Efficient Organization: Reduce the need for multiple separate sheets by consolidating related information
Sheet Detail Components
When working with multi-section and multi-axis sheets, you'll interact with several key components in Sheet Detail:
| Component | Purpose |
|---|---|
| Level 2 Header | Command center for sheet-related actions including saving, refreshing, publishing, and accessing the Metrics List |
| Sheet Header | Defines the sheet's unique identity including name, title, functional area, and privacy status |
| Layout | Where data presentation is defined and fields are structured into rows, columns, and filters |
| Options | Additional features to enhance the sheet's display and fine-tune appearance |
| Fields | Selection and addition of fields from the space to include in the sheet |
Allow Multiple Sections
The Features section in Sheet Detail includes additional options to enhance your sheets.
Allow Multiple Sections
Enables multi‑section functionality within a sheet.
Important: Advanced sheet features require careful planning of your data structure. Before enabling multi‑section or multi‑axis configurations, be sure to consider your reporting requirements and the relationships between fields.