<div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Hi Jonathan</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Thanks for your email, see comments below:</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, May 10, 2022 at 9:05 PM Jonathan Moules <<a href="mailto:jonathan-lists@lightpear.com">jonathan-lists@lightpear.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
  
    
  
  <div>
    <p>Hi Tim,</p>
    <p>This looks good; I love a good dashboard. Some thoughts &
      bugs:</p>
    <p>* Do we have telemetry for QGIS Server?</p></div></blockquote><div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">No - I don't think we will add this.....or at least I don't have any current plans.</div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
    <p>* The numbers on "<b>QGIS Open events on Windows per day - last
        yea</b><b>r</b>" seem far too low. "<b>QGIS Daily Opens - last
        30 days</b>" is showing half a million users a day but for
      windows is just ~50k a day, this despite windows clearly being
      90+% of users per the platform chart (well, one of those platform
      charts...).</p></div></blockquote><div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Only QGIS >= 3.24 reports the platform. This figure will self correct as more people move to more recent builds.</div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
    <p>* Alternately, the pie-chart next to it: "<b>QGIS Daily Opens by
        Platform - last 30 days</b>" is showing 86% as being "other"
      platforms where "others" on the chart to the left of it for what
      appears to be trying to show the same thing is only a tiny
      percentage (< 6%?).<br></p></div></blockquote><div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Again this is explained by the lack of platform reporting in QGIS > 3.24 (see the little info popups on each chart).</div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><p>
    </p>
    <p>* "<b>QGIS Daily Opens by Version - last 30 days</b>" - is
      showing some of the version numbers as integers and some as
      floats.</p></div></blockquote><div><br></div><div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Yes I haven't figured this out yet....it could be bogus User Agents, custom builds of QGIS.....something else?</div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
    <p>* "<b>QGIS Top Movers - Yesterday</b>" - If I sum these up I get
      about 100,000. Given the total number of users yesterday per the
      day-chart was only about 25k higher than a Monday average, I get
      the feeling this is averaging across all-time, meaning weekends
      will always show a low number and weekdays will always show a high
      number (as today). I'd suggest it should probably use the average
      for that-day, so it's comparing like-for-like.</p></div></blockquote><div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Yeah this is a bit of an experiment. It compares the amount of opens yesterday to the average daily opens across all time. I don't know how informative it is, in future I may just remove it.</div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
    <p>* "<b>QGIS Total Number of Opens in this Current Month</b>" at
      the top is wrong - it's identical to "last 30 days" to its left.
      Also the very bottom shows the number should be 3.5 million not 10
      million.</p></div></blockquote><div><br></div><div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Thanks, fixed now.</div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
    <p>* "<b>QGIS Total Number of Opens in this Current Month</b>" at
      the top says 499,262, but the graph (<b>QGIS Daily Opens - last 30
        days</b>) shows 500,359 for yesterday if I mouse over it.</p></div></blockquote><div><br></div><div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">I'm not sure why they are different - will need to poke around some more.</div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
    <p>Assuming it's SQL behind the scenes, I may be able to take a stab
      at it if you want.<br></p></div></blockquote><div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Yes I would welcome your help. I will send you some credentials, but please tray to avoid running any queries that place a high load on the server.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Regards</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;font-size:small">Tim</div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><p>
    </p>
    <p>Cheers,</p>
    <p>Jonathan<br>
    </p>
    <p><br>
    </p>
    <div>On 2022-04-29 22:35, Tim Sutton wrote:<br>
    </div>
    <blockquote type="cite">
      
      <div dir="ltr">
        <div dir="ltr">
          <div style="font-family:arial,helvetica,sans-serif;font-size:small">Hi
            Andreas</div>
        </div>
        <br>
        <div class="gmail_quote">
          <div dir="ltr" class="gmail_attr">On Fri, Apr 29, 2022 at 5:00
            PM Andreas Neumann <<a href="mailto:andreas@qgis.org" target="_blank">andreas@qgis.org</a>>
            wrote:<br>
          </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div>Hi Tim,</div>
              <div><br>
              </div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small">See
              also my answers to Régis for more context. More comments
              below. Note that I share the dashboard publicly so look
              here </div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small"><span style="background-color:unset;color:unset;font-family:unset;font-size:unset;font-variant-ligatures:unset;font-variant-caps:unset;font-weight:unset;letter-spacing:unset;text-align:unset;text-decoration-line:unset;text-indent:unset;text-transform:unset;white-space:pre-wrap;word-spacing:unset">
</span></div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small"><span style="background-color:unset;color:unset;font-family:unset;font-size:unset;font-variant-ligatures:unset;font-variant-caps:unset;font-weight:unset;letter-spacing:unset;text-align:unset;text-decoration-line:unset;text-indent:unset;text-transform:unset;white-space:pre-wrap;word-spacing:unset"><a href="http://feed.qgis.org/metabase/public/dashboard/df81071d-4c75-45b8-a698-97b8649d7228" target="_blank">http://feed.qgis.org/metabase/public/dashboard/df81071d-4c75-45b8-a698-97b8649d7228</a> </span></div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small"><span style="background-color:unset;color:unset;font-family:unset;font-size:unset;font-variant-ligatures:unset;font-variant-caps:unset;font-weight:unset;letter-spacing:unset;text-align:unset;text-decoration-line:unset;text-indent:unset;text-transform:unset;white-space:pre-wrap;word-spacing:unset">
</span></div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small"><span style="background-color:unset;color:unset;font-family:unset;font-size:unset;font-variant-ligatures:unset;font-variant-caps:unset;font-weight:unset;letter-spacing:unset;text-align:unset;text-decoration-line:unset;text-indent:unset;text-transform:unset;white-space:pre-wrap;word-spacing:unset">especially at the little (i) indicators which I tried to populate with more defail.</span></div>
            <br>
          </div>
          <div><br>
          </div>
          <div> </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div>Looks really cool - thanks for working on this! I
                kind of expected the dominance of Windows as an
                operating system, but I am surprised to see one
                particular Windows (Windows 10) take such a large share.
                Many government agencies or companies that I know still
                use older Windows versions.</div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small">I
              guess MS has been working hard to make the upgrade process
              smoother which is IMHO a good thing from a security point
              of view.</div>
            <br>
          </div>
          <div> </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div><br>
              </div>
              <div>I also wonder what hides behind some of the quite
                large bars in the category "Other"?</div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small">We
              can break them out if needed.</div>
            <br>
          </div>
          <div><br>
          </div>
          <div> </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div> <br>
              </div>
              <div><br>
              </div>
              <div>When it comes to QGIS versions, I think we should
                better aggregate only by major versions and for now
                ignore the minor versions. This large fragmentation into
                minor/minor versions seems to lead to this gigantic
                large bar of "Other".<br>
              </div>
              <div><br>
              </div>
            </div>
          </blockquote>
          <div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small">Yes
              it is on my todo list to aggregate all 3xxyy into 3xx so
              they show as one bucket.</div>
            <br>
          </div>
          <div><br>
          </div>
          <div> </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div>Question: is there any chance to put the absolute
                numbers in relation with the rough population size of a
                country. It is only natural that large countries like
                France, Germany, USA and Brazil open QGIS  more often
                than smaller countries. But put in relation with
                population size, the pattern could look quite different.</div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small">The
              first map already does this. The second one shows absolute
              numbers per territory regardless of population.</div>
            <br>
          </div>
          <div><br>
          </div>
          <div> </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div><br>
              </div>
              <div>My cartography teachers told me that it is absolutely
                forbidden to use absolute numbers in choropleth maps -
                ABSOLUTELY FORBIDDEN ! Numbers always need to be put in
                relation with the size (area and/or population) of a
                country.</div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small">He
              is probably right but I think the world of BI (Business
              Intelligence) has largely ignored him and the world is now
              littered with maps like this. I still think it is
              interesting to see the absolute numbers by country.</div>
            <br>
          </div>
          <div> </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div><br>
              </div>
              <div>Thanks a lot for your work to all people involved!</div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small">No
              problem, and again let me extend the invitation to you to
              go onto the backend and help improve the dashboard, this
              is just my first chicken scratch. I think the real value
              will be to see the relative breakdown of platforms,
              versions countries and the changes to these over time so
              we can identify trends. In terms of absolute numbers I am
              still unsure if it tells us a real picture of how many
              users we have.</div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small"><br>
            </div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small">Regards</div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small"><br>
            </div>
            <div style="font-family:arial,helvetica,sans-serif;font-size:small">Tim</div>
            <br>
          </div>
          <div> </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div><br>
              </div>
              <div>Andreas<br>
              </div>
              <div><br>
              </div>
              <div><br>
              </div>
            </div>
            <br>
            <div class="gmail_quote">
              <div dir="ltr" class="gmail_attr">On Fri, 29 Apr 2022 at
                15:57, Tim Sutton <<a href="mailto:tim@kartoza.com" target="_blank">tim@kartoza.com</a>>
                wrote:<br>
              </div>
              <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
                <div dir="ltr">
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small">Hi
                    PSC</div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small"><br>
                  </div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small">I
                    just wanted to give you some feedback on the work we
                    have been doing to use anonymised telemetry data
                    from the feed to try to get a handle on the number,
                    geography and platform choice of our user base.
                    There are detailed notes in the image below
                    which should explain things. Currently it has only
                    been running about 2 weeks so the year and month
                    charts at the end look the same, but you can expect
                    these to diverge over time.</div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small"><br>
                  </div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small">If
                    you have other things you would like to report on
                    with the available data, please pop me a note. I
                    still want to aggregate the platform  better to lump
                    together Win, Mac, Linux and other instead of the
                    more granular breakdown we get right now. I will do
                    so when I get a chance.</div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small"><br>
                  </div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small">I
                    do not plan to make the link to the live dashboard
                    public as I don't want to put load on the feed
                    server, but if you wish to access the dashboard, pop
                    me a note and I will add you.</div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small"><br>
                  </div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small"><a href="https://user-images.githubusercontent.com/178003/165956926-a30c6c96-3b6b-4895-8afb-97e9ba0bd28c.png" target="_blank">https://user-images.githubusercontent.com/178003/165956926-a30c6c96-3b6b-4895-8afb-97e9ba0bd28c.png</a><br>
                  </div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small"><br>
                  </div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small"><br>
                  </div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small">Regards</div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small"><br>
                  </div>
                  <div style="font-family:arial,helvetica,sans-serif;font-size:small">Tim</div>
                  -- <br>
                  <div dir="ltr">
                    <div dir="ltr">
                      <div>
                        <div dir="ltr">
                          <div style="text-align:center">------------------------------------------------------------------------------------------</div>
                          <div style="text-align:center"><img style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px;"><br>
                          </div>
                          <div style="text-align:center">Tim Sutton</div>
                          <div style="text-align:center"><span style="text-align:start">Visit </span><a href="http://kartoza.com/" style="text-align:start" target="_blank">http://kartoza.com</a><span style="text-align:start"> to find out
                              about open source:</span><br style="text-align:start">
                            <span style="text-align:start"> * Desktop
                              GIS programming services</span><br style="text-align:start">
                            <span style="text-align:start"> * Geospatial
                              web development</span></div>
                          <div style="text-align:center"><span style="text-align:start">* GIS Training</span></div>
                          <div style="text-align:center"><span style="text-align:start">* Consulting
                              Services</span></div>
                          <div style="text-align:center">
                            <div style="text-align:start">
                              <div style="text-align:center">Tim is a
                                member of the QGIS Project Steering
                                Committee</div>
                              <div style="text-align:center">-------------------------------------------------------------------------------------------</div>
                            </div>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
                _______________________________________________<br>
                Qgis-psc mailing list<br>
                <a href="mailto:Qgis-psc@lists.osgeo.org" target="_blank">Qgis-psc@lists.osgeo.org</a><br>
                <a href="https://lists.osgeo.org/mailman/listinfo/qgis-psc" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-psc</a><br>
              </blockquote>
            </div>
            <br clear="all">
            <br>
            -- <br>
            <div dir="ltr">
              <div dir="ltr">
                <div><br>
                  --<br>
                  Andreas Neumann<br>
                </div>
                <a href="http://QGIS.ORG" target="_blank">QGIS.ORG</a> board member
                (treasurer)<br>
              </div>
            </div>
          </blockquote>
        </div>
        <br clear="all">
        <div><br>
        </div>
        -- <br>
        <div dir="ltr">
          <div dir="ltr">
            <div>
              <div dir="ltr">
                <div style="text-align:center">------------------------------------------------------------------------------------------</div>
                <div style="text-align:center"><img src="https://mail.google.com/mail/u/0/?ui=2&ik=7ebbf93252&view=fimg&th=15a9e43c0bbf93ca&attid=0.1&disp=emb&realattid=9436e64174762963_0.1.1&attbid=ANGjdJ-WL_J24nvBiYidJ0V0xpdsYqRwswi5nq5oywcJEHC7twYVMrxG0y-GNPu_ahJthV8ktXwYuHoVm5DI2FrRAtPzelTRHrsE2wweR9uu8wT-zz2hNRqFwi4SorQ&sz=s0-l75-ft&ats=1488721675176&rm=15a9e43c0bbf93ca&atsh=1" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px;"><br>
                </div>
                <div style="text-align:center">Tim Sutton</div>
                <div style="text-align:center"><span style="text-align:start">Visit </span><a href="http://kartoza.com/" style="text-align:start" target="_blank">http://kartoza.com</a><span style="text-align:start"> to find out about open
                    source:</span><br style="text-align:start">
                  <span style="text-align:start"> * Desktop GIS
                    programming services</span><br style="text-align:start">
                  <span style="text-align:start"> * Geospatial web
                    development</span></div>
                <div style="text-align:center"><span style="text-align:start">* GIS Training</span></div>
                <div style="text-align:center"><span style="text-align:start">* Consulting Services</span></div>
                <div style="text-align:center">
                  <div style="text-align:start">
                    <div style="text-align:center">Tim is a member of
                      the QGIS Project Steering Committee</div>
                    <div style="text-align:center">-------------------------------------------------------------------------------------------</div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
      <br>
      <fieldset></fieldset>
      <pre>_______________________________________________
Qgis-psc mailing list
<a href="mailto:Qgis-psc@lists.osgeo.org" target="_blank">Qgis-psc@lists.osgeo.org</a>
<a href="https://lists.osgeo.org/mailman/listinfo/qgis-psc" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-psc</a>
</pre>
    </blockquote>
  </div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div style="text-align:center">------------------------------------------------------------------------------------------</div><div style="text-align:center"><div style="color:rgb(0,0,0);font-family:arial,helvetica,sans-serif;font-size:small;display:inline"></div><img src="https://mail.google.com/mail/u/0/?ui=2&ik=7ebbf93252&view=fimg&th=15a9e43c0bbf93ca&attid=0.1&disp=emb&realattid=9436e64174762963_0.1.1&attbid=ANGjdJ-WL_J24nvBiYidJ0V0xpdsYqRwswi5nq5oywcJEHC7twYVMrxG0y-GNPu_ahJthV8ktXwYuHoVm5DI2FrRAtPzelTRHrsE2wweR9uu8wT-zz2hNRqFwi4SorQ&sz=s0-l75-ft&ats=1488721675176&rm=15a9e43c0bbf93ca&atsh=1" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px;"><br></div><div style="text-align:center">Tim Sutton</div><div style="text-align:center"><span style="text-align:start">Visit </span><a href="http://kartoza.com/" style="text-align:start" target="_blank">http://kartoza.com</a><span style="text-align:start"> to find out about open source:</span><br style="text-align:start"><span style="text-align:start"> * Desktop GIS programming services</span><br style="text-align:start"><span style="text-align:start"> * Geospatial web development</span></div><div style="text-align:center"><span style="text-align:start">* GIS Training</span></div><div style="text-align:center"><span style="text-align:start">* Consulting Services</span></div><div style="text-align:center"><div style="text-align:center"></div><div style="text-align:start"><div style="text-align:center">Tim is a member of the QGIS Project Steering Committee</div><div style="text-align:center">-------------------------------------------------------------------------------------------</div></div></div></div></div></div></div></div>