Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'd like to ask how I can calculate the total time between two dates and then display this data in a visual representation?
For instance:
Open Dates:
5/24/2014
6/11/2014
6/22/2014
6/22/2014
9/12/2014
Close Dates:(respectively)
5/24/2014
6/12/2014
6/23/2014
6/22/2014
11/11/1014
Then what I am looking for is a new table that I would like to display in hours
Hours Open:
2
12
14
1
1443
I know how to take the data and display it, but I am more so aiming to display statistics on how long a ticket was open with support or a secondary approver.
Any thoughts?
Thanks Kindly
the first line is a so called preceding load, it takes the result form the load below. I could have loaded the interval in the same load as the dates, but then I would have to repeat the date formatting in that as well.
From the number of questions regarding dates on this forum, dates seem to be difficult. Always check if your dates are loaded as real dates. (see the listbox, I added an expression with Num(date) to check if they were)
Yes you can load from webfiles, in the load script editor click on the Web Files button on the bottom of the screen to start the wizard and paste in the web link.
Now about the negative numbers, you either have a mixed date format or your data is wrong (different sources??). The example in your screenshot show 9/12/2014 and 10/1/2014, which if you take the dateformat of Day/Month/Year is saying that this was created on 9 December 2014 and completed on 10 January 2014, hence the negative number.
Thanks Piet,
I have marked the question as answered as I did indeed find out how to find the difference of two dates and display them.
I have also fixed the negative values by exchanging the month and day in the date format.
However my new problem is something in my data that I do not understand. I will work on it on the meantime, but I may create another forum if I become stuck.
Thank you, gentlemen, for all of your help.