Bug after bug after bug. I am really thankful for the Discord Server where people have reported these problems whenever they notice anything amiss or wrong. Without them, it would be a lot more difficult to find them. You can join our Discord server through this link. I'm keeping also a master list of all known bugs there for everyone to see. While I'm quick to fix them at the moment, I don't see it necessary to keep that kind of list in the blog. However, I've now collected all the bug-fix posts to the Help page too!
One of the users noticed that they had wrong values in All Time Statistics in the Yearly Statistics tab. Some fighting and figuring out later, I'm here to give you fixes. First of all, I left the hidden support columns in the Yearly Statistics tab in such a messy state that I'm embarrassed that you have to see them, but... well, nothing I can do now. So, let's get to work, you know the jazz, I'll give you every step and cell and formula and you'll just follow them and hopefully it will work out! As always, these are already fixed to public files so you can always go to make a new copy for yourself and check out from there how they are set.
1. Grab the Yearly Statistics tab and open hidden columns.
2. Scroll to the right until you see columns Y, Z, AA, AB, AC and AD.
3. In the 2024 version, choose cell Z19. In the 2025 version, choose cell Z3. Hox! On the left side of them, is the text Fandom. Replace the old formula with this one:
=IFERROR(INDEX(UNIQUE(FILTER(R_Fandom, F_ReadingStatus="Read")), MATCH(MAX(COUNTIF(FILTER(R_Fandom, F_ReadingStatus="Read"), UNIQUE(FILTER(R_Fandom, F_ReadingStatus="Read")))), COUNTIF(FILTER(R_Fandom, F_ReadingStatus="Read"), UNIQUE(FILTER(R_Fandom, F_ReadingStatus="Read"))), 0)),"")
4. Go to one row down, so in the 2024 version cell Z20 and in the 2025 version cell Z4. Replace the old formula with this one:
=IFERROR(INDEX(UNIQUE(FILTER(S_MainPairing, F_ReadingStatus="Read")), MATCH(MAX(COUNTIF(FILTER(S_MainPairing, F_ReadingStatus="Read"), UNIQUE(FILTER(S_MainPairing, F_ReadingStatus="Read")))), COUNTIF(FILTER(S_MainPairing, F_ReadingStatus="Read"), UNIQUE(FILTER(S_MainPairing, F_ReadingStatus="Read"))), 0)),"")
5. Go to one row down, so in the 2024 version cell Z21 and in the 2025 version cell Z5. Replace the old formula with this one:
=IFERROR(INDEX(UNIQUE(FILTER(O_Rating, F_ReadingStatus="Read")), MATCH(MAX(COUNTIF(FILTER(O_Rating, F_ReadingStatus="Read"), UNIQUE(FILTER(O_Rating, F_ReadingStatus="Read")))), COUNTIF(FILTER(O_Rating, F_ReadingStatus="Read"), UNIQUE(FILTER(O_Rating, F_ReadingStatus="Read"))), 0)),"")
I know, I might often overdo formulas, stacking them on top of each other more than would be needed, but it's better to be safe than sorry.
I would like to remind you now that when counting the most appearing values, it only takes first-time reads into account. While counting how many of them are read will also count rereads. With Most read fandom, pairing and rating in All time statistics, it counts only first-time reads so basically the reading statuses. I will probably edit formulas one day to count in rereads too but it's something for a later date.
I'm also sorry for all the times I wrote raiting instead of rating! English is not my first language and I'm often having problems with that specific word.
I will probably be back at least once during the weekend, but hopefully, I can also focus on relaxing!