I have a field with type Time (HH:MM:s). The value of the filed is a duration. I need to have average of this field per the section in the report
8 April, 2014
Hi,
In my report I have a field with type Time (HH:MM:s). The value of the filed is a duration. I need to have average of this field per the section in the report. Following illustrate the sampe
Section 1: Total Average duration: 04:25
Field 1 | Filed 2 | Duration
------------------------------------------
sample 1 | Sample 1-1 | 03:00
Sampl2 2 | Sample 2-1 | 05:50
Section 2: Total Average duration: 6 hours
Field 1 | Filed 2 | Duration
------------------------------------------
sample 1 | Sample 1-1 | 3:05
Sampl2 2 | Sample 2-1 | 3:10
Please advise.
Thank you.
Leila
In my report I have a field with type Time (HH:MM:s). The value of the filed is a duration. I need to have average of this field per the section in the report. Following illustrate the sampe
Section 1: Total Average duration: 04:25
Field 1 | Filed 2 | Duration
------------------------------------------
sample 1 | Sample 1-1 | 03:00
Sampl2 2 | Sample 2-1 | 05:50
Section 2: Total Average duration: 6 hours
Field 1 | Filed 2 | Duration
------------------------------------------
sample 1 | Sample 1-1 | 3:05
Sampl2 2 | Sample 2-1 | 3:10
Please advise.
Thank you.
Leila
Hi Leila,
Unfortunately there is no way to display the Total Average as a Title/Heading.
You would have to make use of Average Totalling to display the Average.
You could also include the label as I have done above.
Hope this helps you to achieve what you are trying to do
Regards,
Stephen
Unfortunately there is no way to display the Total Average as a Title/Heading.
You would have to make use of Average Totalling to display the Average.
You could also include the label as I have done above.
Hope this helps you to achieve what you are trying to do
Regards,
Stephen
Hi Stephen,
Thank you for your quick reply. The issue with my time is I cant see the Average Total option. There are only Count and Distinct Count options available.
Please advise.
Thank you.
Thank you for your quick reply. The issue with my time is I cant see the Average Total option. There are only Count and Distinct Count options available.
Please advise.
Thank you.
Hi Leila,
If Count and Distinct Count are you only options, it is likely that you Duration (Time) field is a Text field. In order to use Sum or Average it should be a Numeric field instead.
In the example above, For the Time field I used a Freehand SQL function, to calculate the time difference in seconds between 2 dates.
(Note that the SQL syntax might differ depending on the database you're using)
I then format the display to show Hours, Minutes, Seconds also note the Datatype is Numeric.
Please let me know if this is what you are after
Regards,
Stephen
If Count and Distinct Count are you only options, it is likely that you Duration (Time) field is a Text field. In order to use Sum or Average it should be a Numeric field instead.
In the example above, For the Time field I used a Freehand SQL function, to calculate the time difference in seconds between 2 dates.
(Note that the SQL syntax might differ depending on the database you're using)
I then format the display to show Hours, Minutes, Seconds also note the Datatype is Numeric.
Please let me know if this is what you are after
Regards,
Stephen