Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to average hourly events

Hello ladies and gentlemen, I need help, because I don't understand how to make my chart present the number of events per hour, I want it to appear regardless of the day   Follow the img : https://...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    You can create a measure as below:

     

    Measure = 
CALCULATE (
    COUNT ( 'Events'[Datetime] ),
    FILTER (
         'Events',
        'Events'[DescEvento] = MAX ( 'Events'[DescEvento] )
            && YEAR ( 'Events'[Datetime] ) = YEAR( MAX ( 'Events'[Datetime] ) )
            && MONTH ( 'Events'[Datetime] ) = MONTH ( MAX ( 'Events'[Datetime] ) )
            && DAY ( 'Events'[Datetime] ) = DAY ( MAX ( 'Events'[Datetime] ) )
            && HOUR ( 'Events'[Datetime] ) = HOUR ( MAX ( 'Events'[Datetime] ) )
    )
)

     

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have two columns, the first is for events and the second is for date and time, I would like to know how I can list events by the hour, For example:

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous - So what does your source data look like? As in provide examples of your source data. Like, does it look like this:

 

Event Date
One 6/2/2020 11:09 AM
Two 6/2/2020 12:57 PM
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Follow: 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

      You can create a measure as below:

       

      Measure = 
CALCULATE (
    COUNT ( 'Events'[Datetime] ),
    FILTER (
         'Events',
        'Events'[DescEvento] = MAX ( 'Events'[DescEvento] )
            && YEAR ( 'Events'[Datetime] ) = YEAR( MAX ( 'Events'[Datetime] ) )
            && MONTH ( 'Events'[Datetime] ) = MONTH ( MAX ( 'Events'[Datetime] ) )
            && DAY ( 'Events'[Datetime] ) = DAY ( MAX ( 'Events'[Datetime] ) )
            && HOUR ( 'Events'[Datetime] ) = HOUR ( MAX ( 'Events'[Datetime] ) )
    )
)

       

      Best Regards

      Rena