Sum hours against project

[Phil Grant]

Hi,
It’s been a while since I ‘ve worked with charts so I may be asking a silly question but I’m trying to get a column chart to show a total of hours against different projects.

I have Index 0 set to project (String and Index 1 set to Actual Hrs (number), group by first column and Aggregation set to Sum. but I can’t get a valid chart.

If I set Aggegration to count It shows the total number of entries but not when I set it to Sum.

Any suggestions?

Cheers,
Phil

[Alexander Bautz]

Do you get an error message or just an empty chart? Is the Actual Hrs a number field or a single line of text field?

Also, which version of SPJS Charts are you running?

Alexander

[Phil Grant]

The chart is not empty but looks strange (image attached).
The version is v6.1.5.13.
The field is a number.

Strangley if I use the ID field it does sum the values of the ID, could it be because the number has 2 decimal places?

Attachments:

1. 

   Chart1.jpg
   

[Phil Grant]

Found the problem, there are two fields with numbers in and the one I picked doesn’t actually have any values in so that’s why it wouldn’t work, I picked the wrong field from the sample records we added.

Sorry to waste your time.

[Alexander Bautz]

No problem, I’m glad you figured it out.

Alexander

[Author]

Posts