Forum Discussion

Noak's avatar
Noak
Icon for Helper IV rankHelper IV
8 years ago
Solved

last night alerts

Hello, I would like to count last night alerts and see the difference from 2 night ago .   How can I calculate it?. night is between 22:00 PM to 6 AM.     thank yoy =).
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    Noak

     

     

    To count a night, you may add a flag column to tag if an entry is "night" or not.

     

    IsNight=
IF ( [StartTime] <= TIME ( 22, 0, 0 ) && [EndTime] > TIME ( 6, 0, 0 ), 1, 0 )

    Then you can count "1" values in above column.

     

     

    What do you mean "difference from 2 nights ago"? Can you share some sample data and expected result?

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Noak

 

 

To count a night, you may add a flag column to tag if an entry is "night" or not.

 

IsNight=
IF ( [StartTime] <= TIME ( 22, 0, 0 ) && [EndTime] > TIME ( 6, 0, 0 ), 1, 0 )

Then you can count "1" values in above column.

 

 

What do you mean "difference from 2 nights ago"? Can you share some sample data and expected result?

 

Regards,

  • Noak's avatar
    Noak
    Icon for Helper IV rankHelper IV
    8 years ago

    Tnx for your replay v-sihou-msft

     

    I would like to compare tonigh amount of alerts to a night before amount of alerts and to present the changes in % (if theres an increase or decrease).