# Average time between two fields **URL:** \ **Category:** Dashboards & Reporting\ **Tags:** professional\ **Created:** [October 10, 2023, 1:41pm UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476 "2023-10-10T13:41:43Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![SGarneau](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sgarneau/32/97885_2.png) [@SGarneau](https://community.hubspot.com/u/SGarneau)\ **Post date:** [October 10, 2023, 1:41pm UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476/1 "2023-10-10T13:41:43Z")
Hi ! I want to create a report that will tell me what’s the average time between a deal is closed won and activates. For now, I’m tracking the dates through 2 custom fields I created (date-picker). One is Closed Won Date and the other is Activation Date. But I can’t seem to find a way to associate them and have an average come out of this. There might be other ways to track this data ? I’m open to suggestions on how to create that type of report ! Thank you in advance, ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [October 10, 2023, 1:44pm UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476/2 "2023-10-10T13:44:09Z")
Hi @SGarneau, This is best done through a calculation property (option: time between), see here: [Create calculation and rollup properties](https://knowledge.hubspot.com/crm-setup/create-calculation-properties) Once this property is created, you can display it in reports, for example with the KPI chart type. Best regards! ---
**Author:** ![SGarneau](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sgarneau/32/97885_2.png) [@SGarneau](https://community.hubspot.com/u/SGarneau)\ **Post date:** [October 10, 2023, 2:22pm UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476/3 "2023-10-10T14:22:24Z")
![Capture d’écran, le 2023-10-10 à 10.21.24.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/9/9a6987834fdeabf3af078782563f489db95c437d.png) Hi @karstenkoehler , Thank you for your fast reply. I just was able to create a field Average Activation with the calculation property, thanks ! However the data populated is a date that doesn’t make sense. How can I visualize a number of days ? Thanks ! ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [October 10, 2023, 2:23pm UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476/4 "2023-10-10T14:23:42Z")
Hi @SGarneau, Can you elaborate what doesn’t make sense? I’m not sure I’m following. The more details you provide, the better I can help. ---
**Author:** ![SGarneau](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sgarneau/32/97885_2.png) [@SGarneau](https://community.hubspot.com/u/SGarneau)\ **Post date:** [October 10, 2023, 2:30pm UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476/5 "2023-10-10T14:30:41Z")
Hi @karstenkoehler Let’s say Field 1 is Closed Won Date [date picker] and Field 2 is Activation Date [date picker] Now I have my [time in between] field 3 that calculates time between Field 1 and Field 2, however the data showing up is a date, but I’d need it to be a round number. (i.e: Field 1 = 10/10/2023 and Field 2 = 11/10/2023, I’m expecting Field 3 to = 1 day instead of 01/01/1970 - which does not make sense) Thanks ! ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [October 10, 2023, 2:36pm UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476/6 "2023-10-10T14:36:56Z")
Hi @SGarneau, In your calculation property settings, did you choose the “Time between” option from the drop-down? ---
**Author:** ![SGarneau](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sgarneau/32/97885_2.png) [@SGarneau](https://community.hubspot.com/u/SGarneau)\ **Post date:** [October 10, 2023, 2:42pm UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476/7 "2023-10-10T14:42:49Z")
![Capture d’écran, le 2023-10-10 à 10.42.13.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/1/e1e2bab62b3eef0296eaee9bac464c2946084bd7.png) @karstenkoehler yes ! ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [October 10, 2023, 3:06pm UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476/8 "2023-10-10T15:06:24Z")
Hi @SGarneau, It looks like you set everything up correctly. This might be a bug, it’s hard to say without access to your portal I’d recommend checking with HubSpot support. ---
**Author:** ![deepikaverma](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/deepikaverma/32/671_2.png) [@deepikaverma](https://community.hubspot.com/u/deepikaverma)\ **Post date:** [October 11, 2023, 7:14am UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476/9 "2023-10-11T07:14:56Z")
Hi @SGarneau , This would be a temporary bug since I tried it and it is giving me the values in numbers only not in dates. ![deepikaverma_0-1697008444523.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/8/581ef9ee400e85408f93a5f8c5794b005c7741cf.png) Thanks! ---
**Author:** ![elizheleva](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/elizheleva/32/51055_2.png) [@elizheleva](https://community.hubspot.com/u/elizheleva)\ **Post date:** [October 11, 2023, 2:24pm UTC](https://community.hubspot.com/t/average-time-between-two-fields/91476/10 "2023-10-11T14:24:57Z")
Hi, @SGarneau , From the surface, it does look like everything has been set up correctly. I would be interested, though, in finding out how the custom properties are being updated. Is it possible that the formatting of those properties are causing a glitch in the calculation? It will be beneficial if you could share a screenshot from a specific deal (of course, removing any sensitive information) showing the values for the custom properties, based on which you have the calculation. Also, further context on how those are updated can be valuable, too. Is it via a workflow or in another way? Thanks, Eli