I have similar requirements and agree that this functionality should be available as standard.

### Post

Follow# Why can't we graph off of a report total in Clarizen

I have a user who needs to graph the average of durations assigned to tasks completed during a particular period. So the natural course of things would be to sum the durations, count the number of tasks and then divide the total duration by the total number of tasks to get the average duration per task. I do not have the ability to perform this calculation and put this value on a line graph. This seems like it should be basic functionality but I have been told that this requires a number of PS hours. Why can't we have something so basic and essential be part of the standard functionality offered?

Please sign in to leave a comment.

###
5 comments
Date
Votes

You can simply create a custom field with the calculations included. Create custom field, choose field type numeric, tick formula box. At the bottom of the screen, the formula options appear. Create the calculation using field names and operatives to provide the value of duration average

Hi Antony - I have created calculated fields before. If I understand your comment correctly, I believe that this would apply for a calculation that can be made on an individual record and then added up to "calculated total". The only example that I could think of is if you were trying to determine labor cost for a specific period of time - you could take duration per stays time the labor rate and get cost total for day and then sum up the daily totals as part of the graph to get a grand total.

In my case, I don't know the total number of tasks until the time that the report runs (and it could change depending on when it is run) and I don't know what the duration will be for each task - so I have to have the report determine the total number of tasks, the total duration days, and then perform the calculation and then have that total available to graph. I can't graph that because I can only define that calculation at a "Total" level, not at a "Line" level. If you have done that before, perhaps you could provide an example?

Hi Gary, I don't have a very relevant example for the requested item. However, Below is a formula we use to determine the value of Days between Created On Date and Date Scope Validated.

IF (IsNull($C_DateScopeValidated),NULL,GetWorkingTimeForGivenPeriod('heathrow@sita.aero',$CreatedOn,$C_DateScopeValidated)/Days(1))

The formulas available are very extensive and can be used to provide the value requested in this post

I agree. I don't want to have to use up a custom field to do a calculation that I can do in the report using formula fields. But I would like to graph the sum or average of the formula field in the chart as that is the data that makes more sense in a graph