I'm not certain I understand what you want
are these the results expected?
if so the avg per user is
the session participant count is
and the calculation that is used to get the total right and the detail right is shown below - it uses the fixed ave / user LOD from above
the min()<>max() just looks to put the window ave in the totals row
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Sessions workbookjd.twbx 24.9 KB
Thank you so very much for this, you are my hero today. It appears to have done the trick. It was much more complicated that I thought, so thank you for taking the time to figure it out.
I was ultimately trying to accomplish the ability to see how many sessions are being run by users with an added detail of average session size (dot size) to help identify the quality of our users.
Glad to help out
LODs can be tricky and the trick used to get the totals right is something you just have to be shown -
Other people will use size()=1 which will accomplish the same thing
Have a good week end
Thank you for showing me (and everyone)!