Follow
Reports FAQs

***

The following are frequently asked questions about reports: 

Why does my custom calculation for an hour difference not show the correct result in a column?

On a project report I have a calculation that subtracts Actual Hours (2) from Planned Hours (4). The result I am getting is 120 when it should be 2. 
My calculation is:

valueexpression=SUB(workRequired,actualWorkRequired)

Answer

Fields using hours in Workfront are stored in minutes. When using the field in a calculation the result will be in minutes. To obtain the result in hours, you must divide the result of the calculation by 60. 

The correct calculation is: 

valueexpression=SUB(workRequired,actualWorkRequired)/60

Why is the value of each of my chart elements in a report not displayed on the chart?  

Answer

If you have more than 50 chart elements in a report chart, the value of each element does not display in the chart. 
value_not_showing_in_chart.png

When you have less than 50 elements in a chart, the value of each element displays in the chart. Consider adding a filter or modifying the groupings in the report to limit the amount of items you display in each element of the chart. 
value_showing__less_than_50_items.png

Why do I see my tasks (or issues) when I access the same report (or calendar) as my co-worker and they see their tasks instead?

Answer

The report or calendar might have a wildcard filter variable which points to the user who is logged in. In this case, the report shows information based on the user who is logged in. Adjust the filter to remove the wildcard that points to the logged in user.
__USER.ID_filter_variable.png

For a complete list of user-based wildcard filter variables, see "Wildcard Filter Variables." 

Why does the data in my report seem incomplete?

Answer

This can happen in most cases if you have a limited access that prevents you from seeing items in the system. Additionally, the items that you want to see are not shared with you. 

The creator of the report can edit the report to run it with the access rights of a system administrator, or any Plan user who has access to see the data. 

For more information, see "Running and Delivering a Report with the Access Rights of Another User."

How do I report on tasks (or issues) that I am assigned to, whether I am the Owner on them or not?

Answer

To see all tasks or issues assigned to you, whether you are the Owner (or Primary Assignee) or not, use the following filter in a task or issue report:

  1. Access a Task or Issue report.
  2. On the Filters tab, click Add Filter Rule.
  3. In the Start typing field name ... field, start typing Assignment Users Name, then select it when it appears in the list. 
    NOTE Do not use the Assigned To Name field, as this filters only for the tasks and issues for which you are the Primary Assignee, or Owner.
  4. Select the Equal modifier.
  5. Specify the following user name: $$USER.ID.
    This ensures that you see all tasks and issues that are assigned to the logged in user. You can replace the wildcard with a specific user name. 
    tasks_assigned_to_me_assignment_users_name_filter.png
  6. Click Save + Close.

Why are the Add Issues/ Add Tasks links not appearing at the bottom of my Issues and Tasks lists on a project?

Answer

If you have the correct access and permissions to add issues and tasks to a project, you should see the Add Issues and Add Tasks links at the bottom of the Issues and Tasks lists. However, if you have a Grouping applied to these lists, the links do not display. Remove the Grouping and the links should display so you can add issues and tasks to your projects.  
For information about creating Groupings, see "Creating and Customizing Groupings."

Does the information in my report or dashboard refresh automatically?

Answer

Information in reports or dashboards does not refresh automatically. 

Information can be manually refreshed in a cached report. 
For more information about refreshing a cached report, see "Running Reports."

Information can be manually refreshed in a cached dashboard.
For more information about refreshing a cached dashboard, see "Displaying Dashboards" in the article "Understanding Dashboards."

Can ownership of a report change?

Answer

Ownership of a report cannot change. However, the user who created the report can allow other users to edit the report. The way you can allow users to edit a report depends on the type of user you are.

  • System administrators can allow users with a Plan license to edit reports by configuring the 'Edit' option in the 'Reports' row to include the access to 'Create' a report. 
    For more information, see "Reporting Access."
  • Any end users with access to create and share reports can allow others to edit individual reports by sharing them and giving other users Manage permissions to them.
    For more information, see "Sharing Reports."

Users with permissions to view or manage other reports can copy them and they automatically become the report owner of the copied report. 

***

This is the ONE anchor article for all FAQs about Reporting. Add a new FAQ in the TOC at the top first, then add the answer as a section at the bottom. 

This article last updated on 2018-08-08 20:18:20 UTC