The first week after the release was definitely the busiest with bug reports and fixing them. There is one bug that has been such a nuisance and I'm still trying to get it fixed. It appears in the General Statistics tab with the Most popular in this fandom with some fandoms. I'm trying to map out if there is a specific pattern for this, so please, if you notice this bug, report it through the Bug Report form with the information of with fandom it appears.

 

I've got also some reports from the Fetch Data script when it doesn't do what it should and gives an error message TypeError: Cannot read properties of undefined (reading 'forEach'). So far it seems that it's maybe something on AO3's end (for example slowness as they have also reported that AO3 has been slow lately). So far the script has worked to the same link some time later.

 

If the script doesn't get the data to the file and does not show any error messages, the fanfic is most likely locked and therefore the script doesn't work on it.

 

I've got multiple good questions about the uses of different things and "Can I do this or that" in both Discord and Tumblr. I will gather them together soon, probably doing some kind of a collection blog post. Tumblr is a really good place to ask anything anonymously, but it is also possible through the Request a feature or leave feedback form that is linked to the file's Home tab. You don't need to leave your contact information and if there is a question without an email address, I will answer it at least in Tumblr. :) 

 

But now! To the real bug fix! I did this a bit differently because there were so many formulas to fix. For some reason, Most Popular Fandom and Most Popular Pairing have been giving random results in Yearly Statistics. These are already fixed to the public files so you can always make a new copy for yourself and copy fic information from your old file to the new one. I simplified the formulas a lot, although it meant also leaving out something. In this case, it doesn't count re-read fics when looking for the most common value. However, it will count them when the most common value is found.

 

First of all, you can find all the formulas and probably good enough instructions from this Google Sheets File. You can copy & paste fixed formulas for every year to the hidden support area you can find when you open the Yearly Statistics tab and click a small arrow in the top right corner. 

 

You can find the specific cell you should choose (but only click it once to choose it, not twice to activate it!) from the file. Note that the location is slightly different depending on if you have starting from 2024 or starting from 2025 version.

 

For additional help, please see the video below and if you need help further, please send an email or join my Discord! We can do it over screen share too, if necessary. (Though, it's not my favourite option and I can imagine that it's not that for other people either, especially with completely random, so I always try to get the problem sorted without that.)