Events for a Period time

aescoba — Sun, 11 Sep 2022 15:51:08 GMT

Hello I'm begings to use Power BI and I'm interesting to know if someone can help.

Problem:

How to measure the correct Duration by Hour?

If I sum the column"Hour" I get a wrong value of 143 instead of 104.18 as table below.

My doubt is I need to duplicate the rows breakdown the times or it's possible a metric to analize the data.

Start	End	Duration (sec)	hour
2022-09-09T07:58:15.753	2022-09-09T07:58:21.820	6	7
2022-09-09T07:58:21.820	2022-09-09T08:00:38.357	137	7
2022-09-09T08:00:38.357	2022-09-09T08:04:48.450	250	8

Hour	SUM_Duration by hour	Sum_Duration by period
7	143	104.18
8	250	288.82

Re: Events for a Period time

lbendlin — Mon, 12 Sep 2022 17:14:02 GMT

Your request is much more complex than it may sound. For each event you need to find the intersect of your event interval with the Hour buckets. Events can also span multiple hours and even days.

- Please confirm that second level accuracy is enough. Specify the rounding rules

- Specify the expected bucket sizes (hours/days etc)

- Confirm that you want all this to be done in UTC

- provide sample data that covers all scenarios

topic Events for a Period time in Custom Visuals Development Discussion

Events for a Period time

Re: Events for a Period time