Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have 2 time variables and I want to calculate average difference between them in pivot table.
Please see below.
How can I get it?
Thanks,
it shows wrong results.
In first table I have count for each surveyID by month, time difference should be for these moths
Regards,
Hi Vladimir,
As you have survey ID and respondent ID, you must calculate an average by respondent like this:
=Interval#(Avg(comeDateTime)-Avg(submitDateTime))
Or, call in pivot table your respondent ID to avoid use an average function.
- Javier Florian
Thanks.
100 points
hey ,there ,
now its coming correct....:)
find attachment
Javier_Florian helped with idea.
Please see above his expression