Expand my Community achievements bar.

SOLVED

Trying to create a chart report based off requests working hours

Avatar

Level 4

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).

 

 

 

 

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

 

VictoriaLinn_0-1697464243839.png

VictoriaLinn_1-1697464268520.png

 

 

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

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.

 

VictoriaLinn_0-1697464243839.png

VictoriaLinn_1-1697464268520.png

 

 

Avatar

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?  

Avatar

Level 4

Found it - it's now worked under 'planned hours' thank you for your help and finding the solution!