User Profile
vyuvaraj
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
Calculate duration by hour of day
I have a columns Start time, Stop time Location 6/14/2018 8:26:00 PM 6/15/2018 5:53:00 AM IL The total duration is 567 minutes I need to split duration in to hourly basis.The output I need is like below Date Location 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 6/14/2018 IL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34 60 60 60 60 6/15/2018 IL 60 60 60 60 53 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 I want to plot a graph with Date on x axis and hour of the day on y axis. Any help is appreciated! thanksSolved2.5KViews0likes4CommentsRe: Calculate duration by hour of day
I have a columns Start time, Stop time Location 6/14/2018 8:26:00 PM 6/15/2018 5:53:00 AM IL The total duration is 567 minutes I need to split duration in to hourly basis.The output I need is like below Date Location 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 6/14/2018 IL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34 60 60 60 60 6/15/2018 IL 60 60 60 60 53 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 I want to plot a graph with Date on x axis and hour of the day on y axis. Any help is appreciated! thanks2.5KViews0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.