The following are frequently asked questions about reports:
- Why does my custom calculation for an hour difference does not show the correct results in a column?
- Why is the value of each of my chart elements in a report not display on the chart?
- 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?
- Why does the data in my report seem incomplete?
- How do I report on tasks (or issues) that I am assigned to, whether I am the Owner on them or not?
- Why are the Add Issues/ Add Tasks links not appearing at the bottom of my Issues and Tasks lists on a project?
- Does the information in my report or dashboard refresh automatically?
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)
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:
If you have more than 50 chart elements in a report chart, the value of each element does not display in the chart.
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.
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.
For a complete list of wildcard user-based filter variables, see "Wildcard Filter Variables."
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."
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:
- Access a Task or Issue report.
- On the Filters tab, click Add Filter Rule.
- 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.
- Select the Equal modifier.
- 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.
- Click Save + Close.
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.
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 the "Displaying Dashboards" section in "Understanding Dashboards."
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.