Forum Discussion

Andrew_na_lang's avatar
Andrew_na_lang
Helper V
4 years ago
Solved

Average task per day

Hi Fam,

I have this table visual where it shows the average task per driver from 4/1/2022 - 4-5/2022. 
How could I get the average task per day per driver in the same table visual? 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Andrew_na_lang ,

     

    The denominator should be datediff +1.

    measure = [average task per driver]/(datediff(min(slicer[date]),max(slicer[date]),day)+1)

     

    Best Regards,

    Jay

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Andrew_na_lang ,

     

    The denominator should be datediff +1.

    measure = [average task per driver]/(datediff(min(slicer[date]),max(slicer[date]),day)+1)

     

    Best Regards,

    Jay