Don’t forget to add the columns on the actual spreadsheet! At the moment, I’m not doing anything with that information, not even incorporating it into the graphs or anything, but at some point in the future, with a chunk of daily data, this could add some fun vizualization opportunities.
By the way, and I’m not proud of this, I just checked my spreadsheet and realized I forgot to add the time trigger! So I had my original entry on the 15th and nothing until this very minute. Make sure to do that, otherwise the whole thing is pointless…
Don't forget to add the columns on the actual spreadsheet! At the moment, I'm not doing anything with that information, not even incorporating it into the graphs or anything, but at some point in the future, with a chunk of daily data, this could add some fun vizualization opportunities.
By the way, and I'm not proud of this, I just checked my spreadsheet and realized I forgot to add the time trigger! So I had my original entry on the 15th and nothing until this very minute. Make sure to do that, otherwise the whole thing is pointless...
I added a few lines to the script so that it logs your level:
//writes Level to Collumn I cell.offset(1,8).setValue(level); //Writes the level to Collumn J for when the level has changed if(cell.offset(0,8).getValue() - cell.offset(1,8).getValue() ==0){ cell.offset(1,9).setValue(“”); } else{ cell.offset(1,9).setValue(doc.user_information.level); }
I then Plotted the apprentice items and the levels on this graph
Because I didn’t have a value for J2 (the 11.9216 value above) I made it the intercept of the trendline with this (rounded to 4 digits): =round(intercept(J3:J, arrayformula(row(J3:J)-2)), 4)
I know that this topic was dead for over a year now, but I can’t seem to figure out how to do this.
How did you put vertical bars by the level markers. I can’t find any option in the chart settings that enables this feature, some help please
I’m not asking how to add level data (I have that already), rather I want to know how to add those vertical lines by each level like in the pic I’m replying to.
Hi! I just wanted to say THANK YOU VERY MUCH FOR THIS! I just started, and I love data. So I’m so happy that I can easily track my progress every day. Thank you very much for sharing!
I really like what you’ve done here, only problem is I have no idea about what API’s are or where to get them! Any quick pointers would be appreciated!
I don’t understand this, I follow exactly the same steps shown in the screenshots, but it still shows the original user’s statistics from 2015, when I started using Wanikani in early August, 2017. Please help, I wanna see my statistics as well, what wrong am I doing
The time shows up 4 hours ahead, how do I change this?
Edit: I went to File > Spreadsheet settings, but the time zone was the right one. Just to try it out, I changed the time zone to a random one, but it didn’t seem to affect the sheet at all.
This script is broken. If you faced the issue below, please move to the latest script in the link below:
"Request failed for https://www.wanikani.com returned code 410. Truncated server response: {"code":410,"message":"This endpoint has been removed. Please use our latest API."