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 
3 Likes
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
1 Like
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 
5 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
2 Likes
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!
2 Likes
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
2 Likes
Looks to be as completed as you say Rod.
Activator
| region | Activated summits | total summits | %age complete |
|---|---|---|---|
| G/CE | 5 | 5 | 100.00 |
| G/DC | 7 | 7 | 100.00 |
| G/LD | 55 | 55 | 100.00 |
| G/NP | 29 | 29 | 100.00 |
| G/SB | 8 | 8 | 100.00 |
| G/SC | 12 | 12 | 100.00 |
| G/SE | 14 | 14 | 100.00 |
| G/SP | 16 | 16 | 100.00 |
| G/TW | 5 | 5 | 100.00 |
| G/WB | 23 | 23 | 100.00 |
| GD/GD | 5 | 5 | 100.00 |
| GI/AH | 11 | 11 | 100.00 |
| GI/CA | 5 | 5 | 100.00 |
| GI/MM | 16 | 16 | 100.00 |
| GI/SM | 24 | 24 | 100.00 |
| GI/SW | 9 | 9 | 100.00 |
| GJ/JE | 1 | 1 | 100.00 |
| GW/MW | 40 | 40 | 100.00 |
| GW/NW | 77 | 78 | 98.72 |
| GW/SW | 41 | 41 | 100.00 |
Chaser
| region | Chased summits | total summits | %age complete |
|---|---|---|---|
| G/CE | 5 | 5 | 100.00 |
| G/DC | 7 | 7 | 100.00 |
| G/LD | 55 | 55 | 100.00 |
| G/NP | 29 | 29 | 100.00 |
| G/SB | 8 | 8 | 100.00 |
| G/SC | 12 | 12 | 100.00 |
| G/SE | 14 | 14 | 100.00 |
| G/SP | 16 | 16 | 100.00 |
| G/TW | 5 | 5 | 100.00 |
| G/WB | 23 | 23 | 100.00 |
| GD/GD | 5 | 5 | 100.00 |
| GW/MW | 40 | 40 | 100.00 |
| GW/NW | 78 | 78 | 100.00 |
| GW/SW | 41 | 41 | 100.00 |
3 Likes
This still makes no sense to me. The table in the first post only shows 4 summits activated and chased in 2025 so why is the total 6?
Tim,
I raised this before as I believe the logic regarding ‘Completes’ is not correct and inconsistent compared with activator/chasing statistics.
To me, you can only ever ‘complete’ a summit once for the charts; the date you manage to have activated and chased a summit for the very first time (there may well be many year in between).
If you look at the total figures, this seems to confirm the above. i.e. a complete is only counted once in the total figures.
Therefore, the sum of completes in each year should therefore equal the total completes.
But it doesn’t. The stats allow you to complete every year and it’s counted in that year (wrongly in my eyes) but does not add to the totals.
In contrast, annual activator points for a summit adds to the activator’s annual figures as well as the total activation points.Similarly for daily chasing the same summit. This makes sense.
Therefore, I believe there is an inconsistency with Completes which should only ever be counted once; in the year the complete occurred (and should then be added to the total figure) and should then no longer feature in future years stats.
1 Like
I would hesitate to say that the reason this exists as it does is because where you apply the year filter has a big impact on how much of the database is read and that this probably made sense back when we had a very constrained database.
I think I previously proposed the solution to be to allow a “cumulative” flag or something but haven’t implemented it for a range of reasons - the main one being focused on the big changes last year for SW3 meant I wasn’t planning on big changes to SD3
3 Likes
I’m off topic, but have to recognise your amazing achievement. Congratulations.
Kevin
5 Likes
How many angels can dance on the head of a pin? was a serious topic of discussion among the scholastics.
Perhaps we should concentrate on the real business of SOTA 
Rod
4 Likes
Completing a peak is a function of chasing and activating it. It makes no sense to filter by the last day you activated it, rather more sense to be by the day it’s complete ?
Wondering if we can make a pretty please request to look at changing this ?
Now to Rods point… back to the serious business - Shadow wants some SOTA action now I’m back from France.
1 Like