Layouts

After setting up your database and importing data into PowerTable, you can use different layout views to analyze, organize, and interact with your data. Each layout presents the same data in a format optimized for a specific type of work, helping you gain insights, track progress, and manage records more effectively.

PowerTable supports the following layouts:

Layout	Description
Table	View, edit, and manage records in a spreadsheet-style grid.
Hierarchy	Organize and analyze records in a parent-child hierarchy.
Crosstab	Summarize and analyze data across rows and columns using grouped dimensions and aggregated values.
Gantt	Visualize project timelines, tasks, milestones, and dependencies.
Resource	Analyze resource allocation, workloads, and schedules across projects and tasks.
Calendar	Display records on a calendar to track schedules, events, deadlines, and milestones.
Kanban	Organize and track work items using customizable workflow stages displayed as cards on a board.

Each view provides a different perspective on your data, allowing you to switch between detailed record management, summarized analysis, project planning, scheduling, and workflow tracking as needed.

Table

Table is the default view in PowerTable, where data is displayed in a table or spreadsheet-style format with rows and columns. You can return to the table view from any other view by selecting Layout > Table.

Gantt

Gantt provides a timeline-based visualization of your task and project data. If your table contains activities or tasks with start and end dates, you can use Gantt view to track schedules, progress, and project timelines.

In addition to displaying task durations, Gantt view supports hierarchical task structures, allowing you to organize tasks and subtasks. It also helps you track progress, milestones, and task dependencies in a single view.

To know more about what a Gantt chart is and how to set up Gantt charts in PowerTable, see Gantt view.

Resource

Resource view organizes tasks by assigned resources, so you can review workloads and schedules for each resource. Tasks are grouped by assignee and displayed along with their corresponding start and end dates. This view presents a consolidated view of each resource's workload and schedule.

To know how to configure and customize the properties of the resource view, see Resource view.

This section explains editing the resource view properties.

Hierarchy

As the name implies, this view displays your data in the form of various hierarchical levels.

A hierarchical view is possible for data with a parent-child or nested structure, such as an organizational chart, a product catalog, or a classification system. This view can be enabled when a data table contains fields to represent a self-referential relationship (such as a one-to-many relationship in which one data point refers to another within the same table).

1

Click on Layout > Hierarchy.

2

The Hierarchy Layout Configuration box opens.

Here, you can configure the primary key column and hierarchy column.

3

Select the 'Display Column'.

More information on configuring the hierarchy view is available here.

The data is shown in the hierarchy view as follows:

Hierarchy View

Related content

Layout views