This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Need help with a particular formulae or series of steps please. I have had a look through the community pages and found some help, but nothing really seems to fit the bill and was wondering if you would be issuing an ‘official’ formula as an industry standard like in other products?
We are using Alteryx to plug into our Service Desk and manipulate our data in various ways.
In one of those ways we need to work out the number of Minutes a ticket has been open. This is very simple in Excel etc., but we need Alteryx to do it.
·Between 2 dates (Opened and Closed)
·During Business Hours (9am-5pm), 5 days a week (should be able to change this if need be - 9am-6pm for example)
·Excluding weekends and holidays (holidays should be a text file with ability to load as a separate file with holiday dates in).
I have attached a file with some data on it.
Open date column – M
Closed date column – Q
Result in minutes to be put in Time On Call column – AT.
Check out this macro I have built with your specifications which allows you to specify working days, working hours and also give a file which removes bank holidays for instance.
Note that at present I have built it out to work exactly with the structure of the template dataset given but I will develop it further tomorrow so it can be applied for any file when two date fields are specified.
Hope this fits well with what you want and let me know if you have any troubles with it.
I have also included an example workflow of the macro in action.
Thank you for your reply and for looking into this and for your valuable time in development of a solution. Your macro seems to work really well and what you further propose would be really extremely useful, in fact critical to us.
We envisage using the solution in quite a few instances across many tables in the Service Desk. Not just to calculate Incident downtime, but also Change Implementation times, Problem Solution times and Service Request times but to name a few!
Having a little trouble running the Macro. Getting the following error:
Failure to Import C:\Users\mike.ives\Documents\Analtyics Training Courses\Alteryx Training Files\Useful Macros and Formula\Working+Day+Time+Difference.yxzp. There was an error opening "C:\Users\mike.ives\Documents\Analtyics Training Courses\Alteryx Training Files\Useful Macros and Formula\Working+Day+Time+Difference\Working Day Time Difference.yxmc": This document was created by a more recent version of this application