11 Replies Latest reply on May 15, 2018 7:06 AM by Zhouyi Zhang

# Calculate the chats average per user, day and month

Hello,

as I said before, any help would be much appreciated -please bear in mind I'm a beginner-.

I want to calculated the total chats' average (Id) per user, month and day.

However, that's what I get when I set totals using average:

It shows 1 instead of the total average per user -same patterns per day and month-.

Thanks!

Update:

I took off the id, then applying totals using average has worked:

Still, this step doesn't work for users and months:

Any help here?

Thanks again.

• ###### 1. Re: Calculate the chats average per user, day and month

Hi Paula,

Please check the below,it will guide  you.

BR,

bharat

• ###### 2. Re: Calculate the chats average per user, day and month

Hi Bharat,

thanks for sharing it, but how can I see what they have done, and how can I apply it to solve my issue?

thanks again,

Paula

• ###### 3. Re: Calculate the chats average per user, day and month

hi Paula,

you can download the work book and see the logic and underlying data.

• ###### 4. Re: Calculate the chats average per user, day and month

hi again,

unfortunately, this doesn't help me with my issue, due to the fact that I'm not working with numerical values.

• ###### 5. Re: Calculate the chats average per user, day and month

Hi Paula,

Please post your .twbx file or sample data along with expected result.

• ###### 6. Re: Calculate the chats average per user, day and month

Here is a copy of it. I'm expecting the average.

Thanks,

Paula

• ###### 7. Re: Calculate the chats average per user, day and month

Hi, Paula

Is this what you are after?

ZZ

• ###### 8. Re: Calculate the chats average per user, day and month

It seems so, but the results aren't what I expected.

It's odd, for instance, the recommender '393901157342259896' gas two recommendations 1041 and 1088. However, the results show an average of 38. Does it make sense?

Thanks!

• ###### 9. Re: Calculate the chats average per user, day and month

Hi, Paula

ZZ

1 of 1 people found this helpful
• ###### 10. Re: Calculate the chats average per user, day and month

Yes, it is! It looks far better, thank you.

• ###### 11. Re: Calculate the chats average per user, day and month

You are welcome, Paula

ZZ