Layout Views

After you've set up your database in PowerTable and begun exploring your data, let's look at how you can view or visualize it for a quick summary and analysis.

In PowerTable, you can view your data in four different ways.

  • Table view

  • Gantt view

  • Resource Gantt view

  • Hierarchy view

Each view has capabilities that help you and your team to quickly identify and drill down to the required data. We also provide Gantt and Resource Gantt charts to help you track the progress of activities, milestones, and dependencies. Let's explore them:

1. Table View

This is the default view in PowerTable, where data is displayed in a table format with rows and columns. From other views, you can always return to table view by clicking on Layout > Table.

Table View

2. Gantt View

PowerTable lets you use Gantt charts to visualize your task data. If your table contains a list of various activities or tasks with their corresponding start and end dates, you can use the Gantt option to track their progress.

A basic Gantt chart view is shown below:

A basic Gantt chart

Let's consider another example. This Gantt view, shown below, displays not only the start and end dates but also the subtasks organized in a hierarchical structure, along with information on progress, dependencies, and milestones.

Advanced Gantt chart

This section provides a detailed explanation of how to create Gantt charts to track progress and dependencies between activities.

3. Resource View

When your data is a list of tasks with an assignee column and start and end dates, you can use the Resource layout to view the tasks summarized based on available resources, as well as the start and end dates of each of their tasks.

  1. Click on Layout > Resource.

Click on 'Resource' Layout
  1. The Column Mapping pop-up opens. Select the resource field that you want to use for grouping the tasks, as well as the start date and end date fields from the relevant drop-down menus shown below. Here, we use the field 'QA Assignee' in the Resource drop-down. Click Apply.

Column Mapping for Resource view
  1. The Resource view opens as below. You can see a list of resources, along with their assigned tasks and start and end dates.

Resource view

This section explains editing the resource view properties.

4. Hierarchy View

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.

Select 'Hierarchy'
  1. The Hierarchy Layout Configuration box opens, where you can configure the primary key column and hierarchy column.

Configure Hierarchy column
  1. Select the 'Display Column'.

Display column

More information on configuring the hierarchy view is available here.

The data is shown in the hierarchy view as follows:

Hierarchy View

The following sections provide a detailed explanation of the various views and how to customize them.

Last updated