More Dashboard Fun
Mar. 10th, 2026 06:00 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
artemisdartI added a few cards to the top of the dashboard for the total number of works, total wordcount, # of ships, and # of challenges. I also added counts for the four different ratings.
Here's the unfiltered version! I can change the date range or filter by ship/challenge to see how the stats and trends change.
If I had more data, I'd be able to report on more things. But I never built in fandom, Archive Warnings, Categories, or tags into the database. So to get those on the dashboard I'd have to make up the gap with a few new tables, most probably. All of those are multi-possible (a single fic can have more than one Fandom, etc.), so I'd have to build bridge tables between Dim_Work and the new tables... it's doable, just something I haven't wanted to take on.
Gosh, it's so pretty.
There are more words hiding in the pre-2023 and post-2026 years -- I have some words slotted into 9999-12-31 because it would take too much time and effort to figure out specifically what chapters of what works they should go into -- so the wordcount total isn't as high as in real life. But it's close enough -- only 10K or so off. In a total of about 1.8 million, that's only half a percent. I'll take it! :)
Here's the unfiltered version! I can change the date range or filter by ship/challenge to see how the stats and trends change.
If I had more data, I'd be able to report on more things. But I never built in fandom, Archive Warnings, Categories, or tags into the database. So to get those on the dashboard I'd have to make up the gap with a few new tables, most probably. All of those are multi-possible (a single fic can have more than one Fandom, etc.), so I'd have to build bridge tables between Dim_Work and the new tables... it's doable, just something I haven't wanted to take on.
Gosh, it's so pretty.
There are more words hiding in the pre-2023 and post-2026 years -- I have some words slotted into 9999-12-31 because it would take too much time and effort to figure out specifically what chapters of what works they should go into -- so the wordcount total isn't as high as in real life. But it's close enough -- only 10K or so off. In a total of about 1.8 million, that's only half a percent. I'll take it! :)
