Hi,
I'm going to try and post a separate one as the previous post may no longer prominent and would like to add a bit more context with the scenario I am seeking some help please.
I have a couple of dashboards that are sourcing data from reports from our CRM. One of which is called a Leads report that gives me the Time to First Action, which is the calculation based from when the lead was created in the system to when it was flagged as beinc completed (when an agent had their initial contact with the client). I do have a Created Date and a Completed Date along with a few other information and the column that I am referring to is called Time to First Action, which is displayed in this format 12h 18m as an example (in a Text data type). I also have ones where it has been reflected in days, e.g., 1d 17h.
I have been asked to provide an monthly average on the Time to First Action but my issue is I'm stuck on where to begin as I am no expert and in addition, the Data Type cannot be changed to a number-related data type and this column has a combination of hours, minutes and days. I'd like to highlight that the Created Date and Completed Date are just dates (with the day) and do not include a time, so they are displayed as just dates, e.g. Tuesday, 28 November 2022.
Any insights anyone can provide will be extremely appreciated. I can also provide additional information where needed.
Many thanks!
