What I’m trying to do
I have a file tree structure with:
customer1
|_session1
|_session2
|_session3
customer2
|_session1
customer3
|_session1
|_session2
|_session3
|_session4
|_session5
|_session6
The folders are actually the full name of customers and each page a session with that customer.
I would like a table with a count of the sessions grouped by customer and and the end the TOTAL number of sessions. Something like:
Full Name #sessions
customer1 3
customer2 1
customer3 6
TOTAL xx
What I tried
I tried different things with group by and playing with tags. I can:
- get a table with all my customers (but not the number of session for each)
- get a raw list of all sessions with the name of the customer (but no group by and no session count by customer).
But I don’t see how to achieve what I need. If somebody have an idea, I can try whatever is suggested.
Thank you.