Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
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.
Damn man, you always manage to find my mistake
Maybe using an average bar offset?
Reference lines is only for Core working hours. It should not be changed as per the requirements.
Ha Ha Thanks Sunny