Avg dateDiff() is not working for Min(Start Date) & Max(End Date)

Question & Answer
, ,
1

HI Team,

I am not able to taking Avg of dateDiff() for Min(Start Date) & Max(End Date) so anyone help please how can I calculate ?

When I taking the Avg(dateDiff()) then it is showing only the date duration not the avg

Thanks & Regards
Biswajit Dash

2

What visual type are you using?

3

hi @David_Wong Table Visual only.

4

Can you post a screenshot of your visual?

5

hi @David_Wong this is the below calculation I created for getting Avg of Date Duration Group by with Month

image
image928×486 9.28 KB

If you see I am getting the same average instead of separate Avg value for each month
PFB the picture

image

Thanks & Regard
Biswajit Dash

6

I can’t see how you’re calculating your Min Start Date and Max End Date, but using my own sample data, I was able to get the correct result.

image

image

image

image

image

7

Hi @David_Wong Thanks for your solutions. This things I am able to do but what I asked for I think some data disturbance is in my end so that the calculation is not working correctly.