Forum Discussion
Ignoring blank cells when indexing
I've been working on a self-written daily habit tracker, habits are grouped into 3 categories. I aim to produce a data table that efficiently quantifies/summarises my performance in these habits over...
Apologies, I seem to have missed the link in the text, that does help. I see that your changes are very helpful so thank you very much, I'll adapt the tables in order to implement 'scores'.
I've never used pivot tables before so I agree, I'll need to familiarise myself with their uses.
Again, thanks
I've never used pivot tables before so I agree, I'll need to familiarise myself with their uses.
Again, thanks
Since there are only a few days in the sample data, here's are two revised Pivot Tables that simply show the averages and counts for the full database.
As I've said, though, and as you'll learn when you read up (or YouTube up) on Pivot Tables, the system is smart enough to start itself grouping by month. And you can force other groupings if you would like, by using helper columns to identify, for example, weeks.
- Ahh yes, thanks for that, indeed it appears there's lots to learn about pivot tables. I'll make sure to look into adapting them to my needs.
Thanks!