I believe I’ve had 12 completes this year. Yet the Database table is only showing 6 when I looked:
Is there a problem, or have I misunderstood something ?
Ahh again Popcorn 
time 
Has this happened before @OE5JFE ? looking at a few other activators, looks like it’s pretty wrong.
Well that just ruined 2024 for me already 
.
I rely on completes to motivate my subjects.
1 Like
What exactly is this table meant to show?
EDIT: and completes calculations now running like a dog as everyone and his mate looks up completes tables 
3 Likes
And that’s what is shown when I look up your activator completes view.
Not what I see…… only 6 completes in 2025:
M0JLA has 9 completes in 2025 and yet if you look at the detail, he has none ?
Yes I think so Tim
The table shows summits that have been both activated and chased in the same year
I think you were expecting it to show new completes achieved this year ?
Rick
A little explanation…
A complete is a summit which you have chased and activated. The unfiltered display shows for each complete the activation date and the chase date then the final column is the complete date which is the latest of activation or chase.
So for the “all years” you are asking for "which summits have I chased and activated since SOTA started and you see the total completed summits and the table starts with your earliest completed summit and your last complete summit at the bottom. If I look at that I can see you have 12 summits completed in 2025.
Now there is no date filtering happening in all years. If you turn on the date filter you now select chase and activation dates where the year matches the date filter. This is important because what it actually is doing is asking for "which summits have I chased AND activated in the year selected. So this shows 6 for you in 2025 as that is how many chased and activated in 2025.
If you want to suggest that’s a little obscure I’d agree. That’s because I’m in a good mood because Arsenal lost meaning Liverpool have played the same number of games and are 8 points clear. We play Citeh tomorrow who are 16 points behind with a game in hand. So if we loose we’re still 8 points clear of Arsenal. And if we win, well that will be lovely jubly. 
Yes, it’s one of those bits of database stuff that is not obvious at first. Mostly when you apply filters (date/mode/band) the filter is only applied to either the chase infor you are looking at or the activation info. Very few tables show something which is a combination of chasing and activating and you don’t immediately think that the filter would be applied to both. It’s been this way since completes were added in 2013 vintage ISTR.
So now you and Fraser can chill a little. And Tim, 6 completes all in 2025 before the end of February is a bit good in my book. Just make sure you don’t do too much so you run out of things to chase/activate 
2 Likes
Ok, I think I understand. So when I filter for completes in 2025, it returns peaks that I have already completed AND activated in 2025.
This explains why M0JLA has not completed a new summit in 2025, yet his score is 9 presumably because he has activated 9 peaks in 2025 that he had already completed in previous years.
I expected and wanted to know how many completes I’ve managed to achieve this year
I realise the database query works this way, but it makes absolutely no sense as a user and it’s a somewhat meaningless statistic ?
Sorry, I’m an Arsenal fan. So currently cranky
1 Like
I don’t yet know why Rod M0JLA has 9 for 2025 but it’s a long time since I looked at the SQL for this. The thing to remember is if you ask for a year filter, it’s the number you have both chased and activated that year. Else look at your unfiltered view and go to the end of the page.
1 Like
Thanks for asking the question, Tim. I’d been puzzling over the very same thing! Not super-important in the grand scheme of things, but it was bugging me that I couldn’t work out how the score was calculated when the year filter was applied.
Rick’s reply clarifies things for me…
I was also expecting this!
Always good to have a mystery solved!
I am a bit concerned by this. A while back I completed every summit in G and GW (except Rhinog Fach whch was added after I finished my list 
)
As I have apparently logged 10 G or GW activations in 2025 I think they should all show up as Completes.
No sleep being lost over this on my part but it does seem a bit odd.
73,
Rod