Difference between dates

Prajju

Hi,

 

I am trying to create a visualization which shows the difference between 2 dates and the trend of the date differences over time(what is the average difference in dates and how they have changed over time).

How can I achieve this on Domo?

 

Regards,

Prajwal

Property_Ninja

One thing you can do is group the datediff into buckets using a beastmode case statement. Like for instance if I was looking at the date difference from when a customer clicked a photo and when they edited a photo and I knew my average was 30 days, I may group the number of times the action happened into buckets and look at that over time. For instance, I may group the number of customers who did that action in 0-7 days, 8-14 days, 15-21 Days ... 60+ Days. You can then look at the counts or percentages over time to see if they are increasing or decreasing.

 

One problem with averages is you could have large outliers that can skew your data. If you have 10 customers and 9 completed the action in 1 day versus a customer who it took 100 days to complete, your average would be 10.9 days. If you look at the data in buckets you could potentially say 90% of customers complete the action in 0-7 days, which tells a much different story than it takes 10.9 days on average to complete this action.

 

Hope this helps.

 

Thanks,

 

Brian

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.