Time Average

[#1]

Hi All,

Please find the attached QVW.

Employee 'hr head' has net duration of 10:20 and 'hr payrolladmin' has 05:35.

If both the employees are selected it should show the average of net duration. But curently it shows 'No Data'

Regards,

Keerthi KS

[sunny_talwar · Accepted solution]

May be this?

Just so I don't look like an idiot, I think I should fix this

Avg(Interval(OutTime-InTime,'hh:mm'))

Interval(Avg(OutTime-InTime),'hh:mm')

[swuehl]

Always use aggregation functions in your expressions:

=Interval(Avg(OutTime-InTime),'hh:mm')

Edit:

You also need to apply aggregation functions to the bar offset and other expressions used. I am unsure how you want to display the reference lines etc. in case of multiple employees selected.

[sunny_talwar]

Damn man, you always manage to find my mistake

[swuehl]

Maybe using an average bar offset?

[#6]

Reference lines is only for Core working hours. It should not be changed as per the requirements.

[#7]

Ha Ha Thanks Sunny