Forum Discussion
@davefiddes:
I think I've discovered what's wrong with the graphic you linked. Take a look at the image below, and compare it with your curve after you've set the Average Interval (days) to 1 day, and clicked on the 3m (3 month) button to place the start of October 2018 just a little to the left of centre. It's not just vaguely similar, it's almost exactly identical! Well guess what I plotted --- oh, you know already because I described it in the caption, it's not the IPv6 counts but the rate of change of IPv6 counts, namely their first derivative!
I'm including below the daily samples from mid-September onwards so that you can match the peaks and troughs yourself numerically. To make this easier I've included an additional column, "Increments", which makes any daily excursions from steady growth very easy to spot. The graph above is simply a plot of the Increments column from 2018-09-30 until today.
========== ====== ========== ===== ===== =========
DATE AS Users IPv6 %UKv6 Increment
========== ====== ========== ===== ===== =========
2018_09_15: VIRGIN 11,828,894 2,048 0.01 3
2018_09_16: VIRGIN 11,823,021 2,032 0.01 -16
2018_09_17: VIRGIN 11,808,491 2,052 0.01 20
2018_09_18: VIRGIN 11,805,704 2,065 0.01 13
2018_09_19: VIRGIN 11,799,952 2,069 0.01 4
2018_09_20: VIRGIN 11,795,879 2,082 0.01 13
2018_09_21: VIRGIN 11,784,519 2,103 0.01 21
2018_09_22: VIRGIN 11,780,874 2,147 0.01 44
2018_09_23: VIRGIN 11,772,573 2,163 0.01 16
2018_09_24: VIRGIN 11,766,071 2,166 0.01 3
2018_09_25: VIRGIN 11,755,321 2,164 0.01 -2
2018_09_26: VIRGIN 11,747,966 2,127 0.01 -37
2018_09_27: VIRGIN 11,751,015 2,070 0.01 -57
2018_09_28: VIRGIN 11,751,527 2,056 0.01 -14
2018_09_29: VIRGIN 11,750,014 2,058 0.01 2
2018_09_30: VIRGIN 11,750,876 2,087 0.01 29
2018_10_01: VIRGIN 11,740,277 2,105 0.01 18
2018_10_02: VIRGIN 11,762,729 2,116 0.01 11
2018_10_03: VIRGIN 11,778,530 2,083 0.01 -33
2018_10_04: VIRGIN 11,779,459 2,188 0.01 105
2018_10_05: VIRGIN 11,772,722 2,246 0.01 58
2018_10_06: VIRGIN 11,783,477 2,300 0.01 54
2018_10_07: VIRGIN 11,778,231 2,388 0.02 88
2018_10_08: VIRGIN 11,772,521 2,504 0.02 116
2018_10_09: VIRGIN 11,759,015 2,551 0.02 47
2018_10_10: VIRGIN 11,741,738 2,681 0.02 130
2018_10_11: VIRGIN 11,723,514 2,835 0.02 154
2018_10_12: VIRGIN 11,714,250 2,947 0.02 112
2018_10_13: VIRGIN 11,687,497 3,069 0.02 122
2018_10_14: VIRGIN 11,671,210 3,176 0.02 107
2018_10_15: VIRGIN 11,650,218 3,321 0.02 145
2018_10_16: VIRGIN 11,627,092 3,484 0.02 163
2018_10_17: VIRGIN 11,608,439 3,679 0.02 195
2018_10_18: VIRGIN 11,586,980 3,792 0.02 113
2018_10_19: VIRGIN 11,567,848 3,878 0.02 86
2018_10_20: VIRGIN 11,546,528 4,020 0.03 142
2018_10_21: VIRGIN 11,534,236 4,165 0.03 145
2018_10_22: VIRGIN 11,519,716 4,384 0.03 219
2018_10_23: VIRGIN 11,499,708 4,575 0.03 191
2018_10_24: VIRGIN 11,480,227 4,816 0.03 241
2018_10_25: VIRGIN 11,459,263 4,996 0.03 180
2018_10_26: VIRGIN 11,443,602 5,105 0.03 109
2018_10_27: VIRGIN 11,426,224 5,205 0.03 100
2018_10_28: VIRGIN 11,412,717 5,391 0.03 186
2018_10_29: VIRGIN 11,389,636 5,775 0.04 384
2018_10_30: VIRGIN 11,364,642 5,948 0.04 173
2018_10_31: VIRGIN 11,346,846 6,092 0.04 144
2018_11_01: VIRGIN 11,325,180 6,266 0.04 174
2018_11_02: VIRGIN 11,300,251 6,465 0.04 199
2018_11_03: VIRGIN 11,284,445 6,509 0.04 44
2018_11_04: VIRGIN 11,267,589 6,598 0.04 89
2018_11_05: VIRGIN 11,251,383 6,739 0.04 141
2018_11_06: VIRGIN 11,241,529 6,828 0.04 89
2018_11_07: VIRGIN 11,229,266 6,981 0.04 153
2018_11_08: VIRGIN 11,219,282 7,071 0.04 90
2018_11_09: VIRGIN 11,210,117 7,177 0.04 106
2018_11_10: VIRGIN 11,203,488 7,255 0.05 78
2018_11_11: VIRGIN 11,192,460 7,365 0.05 110
2018_11_12: VIRGIN 11,180,045 7,445 0.05 80
2018_11_13: VIRGIN 11,156,811 7,510 0.05 65
2018_11_14: VIRGIN 11,141,446 7,673 0.05 163
2018_11_15: VIRGIN 11,128,883 7,767 0.05 94
2018_11_16: VIRGIN 11,129,417 7,850 0.05 83
2018_11_17: VIRGIN 11,113,102 7,875 0.05 25
2018_11_18: VIRGIN 11,098,078 7,901 0.05 26
2018_11_19: VIRGIN 11,086,364 8,018 0.05 117
2018_11_20: VIRGIN 11,071,854 8,103 0.05 85
2018_11_21: VIRGIN 11,059,650 8,193 0.05 90
2018_11_22: VIRGIN 11,042,844 8,224 0.05 31
2018_11_23: VIRGIN 11,022,559 8,287 0.05 63
2018_11_24: VIRGIN 10,999,645 8,358 0.05 71
2018_11_25: VIRGIN 10,985,486 8,428 0.05 70
========== ====== ========== ===== ===== =========
DATE AS Users IPv6 %UKv6 Increment
========== ====== ========== ===== ===== =========
This almost perfect match is far beyond any possibility of accident --- they either intended to plot the rate of change or else they have a first derivative term in their plotting code and triggered it through some programming error.
It does at least give us a chance to check the time-sync between their graphics and my CSV tables taken from APNIC's Javascript. The cleanest place to check is the start of October, because it was preceded by a long period of relative quiet, and so a sudden increase will be equally distinguishable in both the counts themselves and in their first derivative. And sure enough, my counts start to skyrocket with the first large increase on 2018-10-04, and their graph spikes too, hence confirming that we are in time-sync on 4th October. Well you can't be in sync on one day and not in sync later on in a daily sampling sequence, it doesn't work that way. :P
In summary, I'm completely convinced that we're both looking at exactly the same data. They've just done something really odd when trying to plot it, either accidentally or by intent.
PS. The fact that despite time-sync at the start of October, the daily counts rise monotonically for almost 2 whole months, from around 2,000 to well over 8,000, and yet that isn't reflected in the graphs you linked, highlights that they're doing something very wrong. Given the time-sync, you can't make one half of a 2-month monotonic rise vanish under any processing I know, unless you're plotting the derivative and so the gradient goes negative as the growth slows down a little.
Morgaine.
Since the graph that @davefiddes linked at https://stats.labs.apnic.net/ipv6/AS5089?a=5089&c=GB&x=0&s=1&p=1&w=30&s=0 will change continually and could lose the extremely close correspondence to my plot of the first derivative of the APNIC daily counts, I'm recording a copy for us here:
It's the portion from the Oct 2018 line just left of centre towards the right that matches very closely, as this is the 3-month view. You can match the peaks and troughs, one by one. :P
Related Content
- 4 months ago
- 1 year ago
- 1 year ago