Trouble getting duel times and time taken in visual

[Aeden]

I have a database that populates two fields Timein, and Timeout in a single row, however Timeout is not always populated, these times go down to 0.00x, as they can be done very quickly, but also take hours. 

What i am trying to do is display against an X axis of time interval <Sec/Min/5Min/30min/etc> against a Y axis of counts of Timein and Timeout that occured within said interval and any spread between Timein and Timeout. 

Currently got as far as using a seperate table given me the X axis providing Min intervals, but when i try and graph the Time counts, its giving me constant rate, as opposed to the count at that interval? 

Not sure what i am missing with this

[Aeden]

Sorry, that first link does contain some useful points to what i am trying to do.

We receive requests into Datebase, logged as Time In (year-month-day hour-min-sec.0000 format),
Application does work, then modifies the Time Out coloumn (year-month-day hour-min-sec.0000 format).

example here:

Time In	Time Out
20/10/2022 00:00:00.391	20/10/2022 00:01:41.818
20/10/2022 00:00:01.678	20/10/2022 00:00:31.365
20/10/2022 00:00:02.865
20/10/2022 00:00:04.160	20/10/2022 00:01:19.466
20/10/2022 00:00:07.157	20/10/2022 00:01:02.633
20/10/2022 00:00:07.235	20/10/2022 00:00:39.922
20/10/2022 00:00:07.313	20/10/2022 00:01:13.716
20/10/2022 00:00:07.334	20/10/2022 00:00:30.388
20/10/2022 00:00:08.604	20/10/2022 00:00:34.637
20/10/2022 00:00:08.688	20/10/2022 00:03:07.453
20/10/2022 00:00:10.507	20/10/2022 00:00:40.662
20/10/2022 00:00:10.765
20/10/2022 00:00:10.825	20/10/2022 00:01:57.868
20/10/2022 00:00:11.079	20/10/2022 00:00:35.435
20/10/2022 00:00:11.225	20/10/2022 00:00:47.635
20/10/2022 00:00:12.100	20/10/2022 00:00:42.081
20/10/2022 00:00:12.643	20/10/2022 00:01:21.561
20/10/2022 00:00:13.092
20/10/2022 00:00:13.654	20/10/2022 00:05:08.078
20/10/2022 00:00:14.239	20/10/2022 00:01:26.818
20/10/2022 00:00:14.874	20/10/2022 00:00:44.271
20/10/2022 00:00:15.814	20/10/2022 00:00:39.821
20/10/2022 00:00:17.000	20/10/2022 00:00:39.821
20/10/2022 00:00:18.105	20/10/2022 00:00:45.533
20/10/2022 00:00:20.016
20/10/2022 00:00:20.397	20/10/2022 00:00:29.090
20/10/2022 00:00:21.099	20/10/2022 00:01:02.285
20/10/2022 00:00:21.180	20/10/2022 00:01:07.323
20/10/2022 00:00:22.353

We are trying to graph both these values individually against the time interval (X plot on graph. 
giving us X Time In in time interval, and Y TimeOut in time interval (and ignore rows with bank Time Out)

But im just getting the entire count for every time interval (set at 1 min in example) rather than 20 Time In counts at 00:00:001 and 40 at 00:00:02 and 3 at 00:00:03 as per data table. (even with filter to not show blank rows)

Furthering on from that would be graphing the difference between the two at the Time Interval as an average, giving us In/Out speed per Time Interval.

On Trying to do a time taken coloumn based on TimeOut-TimeIn, the new coloumn seems to either throw an error due to format of data, or result in decimals which dont reflect what you'd get just working it out. 

I do have an incling that this is stringing together features rather than a single fix, im just struggling to get there. 

[v-yiruan-msft · Accepted solution]

Hi @Aeden ,

Please review the solution in the following thread and check if that is what you want.

Visualizing time intervals

Best Regards

[Greg_Deckler]

@Aeden Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.