This content has been marked as final. Show 2 replies
I Load the sample data this way and want to get difference in the seconds how can i do this in script in place of this
Interval( [Close Date Time] - [Create Date Time], 'DD' ) want to get seconds difference in script and then average.
Interval( [Close Date Time] - [Create Date Time], 'DD' ) AS DiffDays
Now in front end just use
And calculate Average in bar chart this way.
Dim : Region
Expression :- Sum(DiffDays)/Count(Id)
Note:- Here my question is what is the unit of measurement of this average calculation in expression.
I attached the sample data.
Any one reply on this.