Calculate time difference in expression

[Anonymous]

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,

[Anonymous]

it shows wrong results.

In first table I have count for each surveyID by month, time difference should be for these moths

Regards,

[javier_florian · Accepted solution]

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

[Anonymous]

Thanks.

100 points

[preminqlik]

hey ,there ,

now its coming correct....:)

find attachment

[Anonymous]

Javier_Florian  helped with idea.

Please see above his expression