User Profile
Deaviouspeanut
Regular Visitor
Joined 2 years ago
User Widgets
Contributions
Wait Time Calculation
I'm trying to work out wait times and be able to work out average wait times and Graph I have the table set up with Arrival time and Consultation time see below I have created a custom Column called wait time which is consultationtime - Arrivaltime, The results are shown below, there's no issue with the results this column gives me, the issue comes when I try to find min and max or graph, it completely ignores the hours and just graphs the minutes (eg the 2hr 18 min result is just seen as 18 min). this then throws out the wait times and reports incorrectly. I've tried setting up the Wait time column using Datediff, however this formula isn't recognised for some reason, I've tried using time.minute, this just gives me the minutes ignoring the hours, similar if I used time.hour just gives me the hours and ignores the minutes. Happy if it just gave me the reading with just the minutes eg. 1:30 just came back as 90 etcScatter Graph
Hi All I'm trying to create a scatter Graph in BI, I'm not fluent in scatter graphs in general I keep getting stuck on the plotting side I Put either the Date Received or the Actioned Date in the X-Axis and then it won't let me put the other into the y-axis, the data I'm plotting is the values below. Some of the values in Actioned are null at this stage Any help would be appreciated, I'm happy to Transform the columns if needed Date Received Referral Status Actioned Date 14/06/2023 19:40 3 25/06/2023 15:46 2 12/07/2023 16:47 4 12/07/2023 17:47 18/07/2023 10:36 2 31/07/2023 9:20 3 31/07/2023 10:54 31/07/2023 9:49 3 31/07/2023 10:54 7/08/2023 9:59 2 7/08/2023 10:59 8/08/2023 13:48 2 9/08/2023 8:56 8/08/2023 16:57 2 9/08/2023 10:44 8/08/2023 19:23 2 9/08/2023 10:44 9/08/2023 10:32 2 9/08/2023 12:48 9/08/2023 17:13 2 10/08/2023 8:40 9/08/2023 17:20 2 10/08/2023 8:39 9/08/2023 17:27 2 10/08/2023 8:38 9/08/2023 18:19 2 10/08/2023 8:37 10/08/2023 21:47 2 11/08/2023 9:20 10/08/2023 23:49 2 11/08/2023 9:15 11/08/2023 4:38 2 11/08/2023 9:40 11/08/2023 9:06 2 11/08/2023 11:18 11/08/2023 9:50 2 11/08/2023 11:18 11/08/2023 16:03 2 11/08/2023 16:42 11/08/2023 16:23 2 11/08/2023 16:41 11/08/2023 18:55 2 12/08/2023 8:31 11/08/2023 19:56 2 12/08/2023 8:40 11/08/2023 20:23 2 12/08/2023 8:44 11/08/2023 22:19 2 12/08/2023 8:50 11/08/2023 23:34 2 12/08/2023 9:18 12/08/2023 3:48 2 12/08/2023 9:20
