All articles

Report Table Charts

Regular Users on Business and Enterprise accounts can create Reports.

⏱ 4 min read

Overview

Wrike Report table charts show you the number of tasks or Projects that meet the criteria you select in the Report Builder. Table charts can have up to ten Groupings, allowing you to build complex reports which capture a high level of detail.

Overview.png

Best Practices

Table charts are best used when you need to:

  • View a count of the number of tasks or Projects which meet specified criteria.
  • Access tasks and Projects directly from the report (this allows for quick editing).
  • Export your report to Excel.

Use table charts to:

  • Track team performance. Keep an eye on how team members are doing, based on key metrics.
  • Monitor accomplishments. Run reports on the work completed last week, month, or quarter.

Groupings on Table Charts

Groupings are available when viewing tasks in custom grouping mode. 

Groupings dictate how Tasks or Projects are organized on table charts.

Edit Groupings from the Table Chart

  • Add a Grouping: click the "+" icon 1 above the table chart to add a new grouping to your chart
  • Remove a Grouping: hover over a grouping and click the 'x' 2 that appears to the right of the grouping's name. 

GroupingsTable.png

Table Chart Grouping Options

 Projects Tasks Timelog Entries
Project Owner Assigned to Date
Status Status Group Parent Folder
Start Date Status Task Title
Finish Date Workflow User
Parent Folder Start Date Comment 
Created Date Due Date Time Spent 
Author Duration  
Project Creator Parent Folder  
+ Custom Fields Author  
  Importance  
  Created Date  
  Completed Date  
  + Custom Fields  

Display Options: Structured (Hierarchical) or Custom Grouping

Structured (Hierarchical) View

Use the hierarchical view to see items organized by Folder, Project, and Task location. This is the same way items are displayed on the Table View

Switch to this view: Click the  button in the chart's upper left-hand corner. Note! You can't use Groupings when you're using this view. 

 Custom Grouping View

Use custom grouping when you want to display tasks based on applied Groupings. 

Switch to this view: Click the  button in the chart's upper left-hand corner. 

Edit and Adjust Table Charts

  • Edit a Report
  • Refresh a Report
  • Expand or Collapse all Sections
  • Expand or Collapse Individual Sections
  • Add or Remove Columns 
  • Change Column Order

Edit a Report

If you need to change which Folders and/or Projects information is pulled from, which filters are applied, or what Groupings are being used, you can edit your Report by returning to the Report Builder.

To do this: click “Edit” 1 in the chart’s upper right-hand corner.

Refresh a Report

When you want (or need) to you can refresh your report to ensure that you are seeing the most up-to-date data.

To do this: click the refresh icon 2 in the chart’s upper right-hand corner.

Expand or Collapse all Sections

Collapse all sections (either Groupings or Folders/Projects depending on what View you're in) to get an overview of the number of tasks in a section or expand all sections to see a more detailed view.

To do this: click "Expand all" 3 or "Collapse all" 4 in the chart’s upper right-hand corner to expand or collapse sections respectively.

Expand or Collapse Individual Sections

Customize your view so that you see only the Groupings, or Folders/Projects/Tasks you are interested in.

To do this: click the carrot icon 5 to the left of each Grouping or Folder/Project name to expand or collapse that section.

Add or Remove Columns

You can add or remove columns related to: Project or Task attributes (depending on which type of report you built) and Custom Fields.

To do this: click the gear icon 6 in the table’s left-hand corner and check or uncheck the box next to each column name to add or remove that column from the report.

Change Column Order

Rearrange the order of columns on the table report to see data in the sequence which best suits your needs.

To do this: click on a column and drag it to appropriate location on the table chart. 

EditAdjust.png

Text Wrapping

Users can enable the option to have text in Report cells wrapped. When you enable text wrapping: all text in that field becomes visible (instead of cutting off if the text is long).
To enable text wrap: click the menu button in the upper right-hand corner and select "Text Wrap".

Note, that text wrap works with Reports that are 500 lines or less.

Undefined Data

A "none" section is added to Reports if there are tasks or Projects which meet the Report's criteria, but the tasks/Projects don't have information entered in the field that you're grouping by. For example,

  • A task without a designated start date would have undefined start date data and, if you're grouping by start date, that task would go in the "None" section.
  • If a Project report is grouped by a Custom Field and the Project doesn’t have data entered for that Custom Field, then that Project appears in the “None” section. 

UndefinedData.png

More Info

0 comments

Article is closed for comments.

Top