## Wordkaspace top column table summary

marion33678522

Total Posts

170

Likes

164

5

marion33678522

Total Posts

170

Likes

164

5
marion33678522

04-09-2017

I have a question on the summary numbers that aree shown on top of each frefform table column.

I'can't figure out how is this number related to all the other rows. I assumed it would be the mean of each row ( the metric is time spend per visit over 7 days (dimension)).

I'm not getting the same results if I do the mean for each roz.

Thaks a lots !

Cheers ,

Mario

View Entire Topic

marion33678522

Total Posts

170

Likes

164

5

marion33678522

Total Posts

170

Likes

164

5
marion33678522

05-09-2017

Hello urs.boller !

But I'm sill a little bit confused ...

how do I excluded those midnight double visits ?
I understand that the summary number in the column header exludes the midnight double visits since this summary number is smaller than the sum of each row .

For example, here, I can surmise that there were 2 visits counted double at midnight.

Visits       Time Spent per Visit
Day           8                                  x
1.              3                                  a
2.              4                                  b
3.              3                                  c

How do I get a total time as you explain in 1) excluding my double visits from each row ?
When I finally divide by any total of visits ( with or without the double visits) I get a wrong Time per Visit header...

Cheers !

Mario