Display Events over a period of 24h

[Benjamin4312]

Hello guys

I would appreciate your help a question. I would like to display events over a period of 24hours (starting and ending at 12:00AM) I kind of managed to it but the problem is, that my start and end event is starting/ending on the previous/following day, so it doesnt show the full 24h. If I set the filter for the day I want to analyse it doesnt include the actual start/end date of the first and last event showing in the table below, because they are on a different day. (So far I used the visual (Event Viewer Chart)

The result should look like on the second picture on the Top:

Name_EF	StartTime	EndTime	OperationMode
Line 1	09.08.2022 17:00	10.08.2022 05:00	Pause|Mitarbeiter
Line 1	10.08.2022 05:00	10.08.2022 05:30	Anfahren
Line 1	10.08.2022 05:30	10.08.2022 09:30	In Betrieb
Line 1	10.08.2022 09:30	10.08.2022 10:00	Pause|Mitarbeiter
Line 1	10.08.2022 10:00	10.08.2022 11:30	In Betrieb
Line 1	10.08.2022 11:30	10.08.2022 11:45	Operative Stopps
Line 1	10.08.2022 11:45	10.08.2022 17:00	In Betrieb
Line 1	10.08.2022 17:00	11.08.2022 05:00	Pause|Mitarbeiter

[v-shex-msft]

Hi @Benjamin4312 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[transform99]

There are a number of ways you can approach this. I would recommend that you use the StartTime column as your point of reference (this means if the event did not "start" on the day [regardless of whether it finished on the day] it is ignored).

You will need to create a measure that filters on the StartTime by checking if it within the parameters of that day (e.g. AND( >= Today(), <= Today()).

[lbendlin]

but the problem is, that my start and end event is starting/ending on the previous/following day, so it doesnt show the full 24h.

Create a measure for all events that start or end within your 24hr period. Use that measure to filter your visual.