Forum Discussion

maheshwarineha's avatar
maheshwarineha
Frequent Visitor
2 years ago
Solved

Recognize peak entry times

How to find the peak time from a datetime column and show it in visual.

 

Sample data:

entry time
02-01-2023 00:58:36
04-01-2023 09:12:41
04-01-2023 19:36:58
04-01-2023 18:08:24
04-01-2023 12:47:17
04-01-2023 19:06:20
07-01-2023 01:13:52
07-01-2023 05:28:54
07-01-2023 18:09:17
07-01-2023 00:13:20
07-01-2023 09:55:14
08-01-2023 13:39:52
08-01-2023 19:35:27
08-01-2023 04:56:45
08-01-2023 10:58:22
08-01-2023 01:00:01
09-01-2023 14:16:59
09-01-2023 15:09:10
09-01-2023 14:10:12
09-01-2023 17:25:30
09-01-2023 18:55:21
09-01-2023 11:56:11

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi maheshwarineha ,

    I create a table as you mentioned.

    Then I create two calculated columns.

    Hour = HOUR('Table'[entry time]) 
    Entries =
COUNTROWS (
    FILTER ( 'Table', HOUR ( 'Table'[entry time] ) = EARLIER ( 'Table'[Hour] ) )
)

    Finally I put it into the visual and it will give you the result.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi maheshwarineha ,

    I create a table as you mentioned.

    Then I create two calculated columns.

    Hour = HOUR('Table'[entry time]) 
    Entries =
COUNTROWS (
    FILTER ( 'Table', HOUR ( 'Table'[entry time] ) = EARLIER ( 'Table'[Hour] ) )
)

    Finally I put it into the visual and it will give you the result.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.