<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<p>Assuming it's SQL behind the scenes, I may be able to take a stab
at it if you want.<br>
</p>
<p>Cheers,</p>
<p>Jonathan<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 2022-04-29 22:35, Tim Sutton wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAES-DZRdwdGF5T1E7vTdJLmRS7daTX7mnnjpXoiCkXbETEhhEw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">
<div class="gmail_default"
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"
moz-do-not-send="true" class="moz-txt-link-freetext">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 class="gmail_default"
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 class="gmail_default"
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;word-spacing:unset">
</span></div>
<div class="gmail_default"
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;word-spacing:unset"><a href="http://feed.qgis.org/metabase/public/dashboard/df81071d-4c75-45b8-a698-97b8649d7228" moz-do-not-send="true" class="moz-txt-link-freetext">http://feed.qgis.org/metabase/public/dashboard/df81071d-4c75-45b8-a698-97b8649d7228</a> </span></div>
<div class="gmail_default"
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;word-spacing:unset">
</span></div>
<div class="gmail_default"
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;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 class="gmail_default"
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 class="gmail_default"
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 class="gmail_default"
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 class="gmail_default"
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 class="gmail_default"
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 class="gmail_default"
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 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> </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" moz-do-not-send="true"
class="moz-txt-link-freetext">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" moz-do-not-send="true"
class="moz-txt-link-freetext">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;"
moz-do-not-send="true"><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"
moz-do-not-send="true"
class="moz-txt-link-freetext">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" moz-do-not-send="true"
class="moz-txt-link-freetext">Qgis-psc@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/qgis-psc"
rel="noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">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"
moz-do-not-send="true">QGIS.ORG</a> board member
(treasurer)<br>
</div>
</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"><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;" moz-do-not-send="true"><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" moz-do-not-send="true"
class="moz-txt-link-freetext">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 class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-psc mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-psc@lists.osgeo.org">Qgis-psc@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-psc">https://lists.osgeo.org/mailman/listinfo/qgis-psc</a>
</pre>
</blockquote>
</body>
</html>