Layout Views

Now that you've set up your database on PowerTable and learned how to work with and explore 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

  • Gantt

  • Resource

  • Hierarchy

Each view helps you and your team to quickly identify and drill down to the required data. We also offer ways to efficiently track the progress of activities, milestones, and dependencies using a Gantt chart. Let's explore them:

1. Table View

Table view is the default view 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 allows you to visualize your data using Gantt charts. If your data table contains various activities or tasks with their corresponding start and end dates, you can use the Gantt option to track their progress.

Gantt view

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 explained 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