Forum Discussion

sparkplug93751's avatar
sparkplug93751
Helper II
6 years ago
Solved

Average Day Per Month

Hello, 

 

I have a data set that logs each time somebody signs in.

 

Everytime somebody signs in, a row is created ie if 15 people sign in then 15 rows are added.

 

I want to calculate the average number of rows per day for a month. ie if there's a total of 62 for the month of may, avg would be 2

 

Currently using:

if(hasonevalue(table1[monthend], calculate(averagex(values(table1[date],calculate(count(table1[names]),table1[occupation<>blank()),calculate(calculate(count(table1[names],table1[occupation]<>blank())

 

Any help is greatly appreciated. I think I'm overthinking this

 

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    sparkplug93751 ,

    Assume your logic is correct

    if(hasonevalue(table1[monthend], 
averagex(summarize(table1[date],"_1",calculate(count(table1[names]),not(isblank(table1[occupation])))),[_1])
,calculate(count(table1[names]),not(isblank(table1[occupation]))))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    sparkplug93751 ,

    Assume your logic is correct

    if(hasonevalue(table1[monthend], 
averagex(summarize(table1[date],"_1",calculate(count(table1[names]),not(isblank(table1[occupation])))),[_1])
,calculate(count(table1[names]),not(isblank(table1[occupation]))))