I have an Excel log that tracks individual occurrences of a particular event during each day. One row per occurrence, date, time, certain other variables. There are between 0 (unusual) and 15 daily occurrences, generally about 3-5/day. I am interested in the weekly trends over time. I now have about 18 months of daily data.
In a PVT I can easily count a weekly total (Pivot Analyse/Group/Day/7 days) for each week. What I want is a daily average by week, rather than a total by week.
HAve you tried using the averae formula instead of the total?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
G'day, that creates DIV/0 in that situation.
yes you have to use the IFERROR funtion
Perhaps an example log and PVT would be more useful. In the attached example PVT tab, you will see weekly total counts and an associated graph. What I want to show is the daily average, not the total, for each week. E.g. for week commencing 1 May 22, I want to display 2.7, not 19.
You could take a look here,
https://techcommunity.microsoft.com/...5697fc2c43e563
You'll probably have to do something with helper columns
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks