Forum Discussion

giorgilomidze's avatar
giorgilomidze
Resolver I
8 years ago
Solved

Average Count Per Day

Hi, 

I have tasks which have start time and end time. 
I took those tasks and distributed them on 24 H basis and it shows me on line chart how task creation and task finishing times are distributed on 24 H x axis. But it shows me the whole count from first period till last day. I need it to show me on average what amount of tasks is created per hour, distributed on 24H x axis. 

 

Need Help
  • OwenAuger's avatar
    OwenAuger
    8 years ago

    Hi,

     

    It sounds like, for each hourly block, you want to calculate a count per day and average those counts over your entire date range. For that you would need to use the AVERAGEX function.

     

    Treat this as a template as I'm not sure of your table/column names, or whether you have a Date table:

     

    =
AVERAGEX (
    VALUES ( 'Date'[Date] ),
    CALCULATE ( COUNT ( YourTable[YourColumn] ) )
)

    A measure like this would work whether you're looking at hourly blocks or complete days.

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Super User
    8 years ago

    Hi,

     

    It sounds like, for each hourly block, you want to calculate a count per day and average those counts over your entire date range. For that you would need to use the AVERAGEX function.

     

    Treat this as a template as I'm not sure of your table/column names, or whether you have a Date table:

     

    =
AVERAGEX (
    VALUES ( 'Date'[Date] ),
    CALCULATE ( COUNT ( YourTable[YourColumn] ) )
)

    A measure like this would work whether you're looking at hourly blocks or complete days.