Trying to create a chart report based off requests working hours

3 replies
633 views
Translate All

Has anyone created a report based on a requests' working time / planned hours? (Screenshot 1 attached)

Am I doing something wrong? (screenshot 2 attached) based on my reports groupings and chart (screenshot 3 attached).

The chart pulls through as number of entries as opposed to number of hours from the requests. (screenshot 4 attached).

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

VicSellersAccepted solution

Adobe Champion, Community Advisor, UG Leader

Hi @jaxelle - In a chart report, to get the chart to pull the number of hours instead of count, try adding a column for the hours field and then choose Sum under "Summarize this column by" > this column will then show as an option under Charts.

VicSellers

Accepted solution

Adobe Champion, Community Advisor, UG Leader

Hi @jaxelle - In a chart report, to get the chart to pull the number of hours instead of count, try adding a column for the hours field and then choose Sum under "Summarize this column by" > this column will then show as an option under Charts.

Translate

J

JaxelleAuthor

Level 4

Thanks for your help Victoria.

Nearly there! Screenshots attached. They're all just showing as 0. The 'original planned hours' is coming under 'project' when I want it to be for all the individual requests but it doesn't show as an option/ I don't see anything close enough to the planned hours? any idea? 🙂

Translate

Sign up

Login with SSO

Login to the community

Login with SSO