From StatsJam
[edit] Basic User Stats
On this page, we perform basic summaries of ingimp installations. These are for significant users, only (see Defining Significant Users for more information about this concept).
[edit] Installed Versions
This form gives you a chance to modify the query and quickly see
the results but it does not update the wiki page..
<query>
SELECT
gimp_version AS "GIMP Version",
COUNT(user_id) AS "count"
FROM
(SELECT
interaction_log.user_id,
MAX(gimp_version) AS "gimp_version"
FROM
interaction_log
WHERE
interaction_log.user_id IN (SELECT user_id FROM significant_users)
GROUP BY
interaction_log.user_id) AS version_table
GROUP BY
gimp_version
ORDER BY
gimp_version
</query>
<view type="table" caption="Installed Versions of ingimp"/>
Installed Versions of ingimp| GIMP Version | count |
|---|
| 2.2.13 | 4 |
| 2.2.14 | 50 |
| 2.2.15 | 31 |
| 2.2.16 | 19 |
| 2.2.17 | 68 |
| 2.3.16 | 3 |
| 2.4.3 | 7 |
| 2.4.4 | 8 |
| 2.4.5 | 7 |
| 2.4.6 | 9 |
| 2.4.7 | 6 |
[edit] Platforms
This form gives you a chance to modify the query and quickly see
the results but it does not update the wiki page..
<query>
SELECT
platform AS "Platform",
COUNT(user_id) AS "count"
FROM
(SELECT
DISTINCT interaction_log.user_id,
platform
FROM
interaction_log
WHERE
interaction_log.user_id IN (SELECT user_id FROM significant_users)) AS platform_table
GROUP BY
platform
ORDER BY
platform
</query>
<view type="table" caption="Platform Stats"/>
Platform Stats| Platform | count |
|---|
| darwin | 1 |
| linux2 | 56 |
| win32 | 156 |
[edit] Monitors
This form gives you a chance to modify the query and quickly see
the results but it does not update the wiki page..
<query>
SELECT
monitor_width AS "Width",
monitor_height AS "Height",
num_monitors AS "n",
ROUND(num_monitors * 100.0 / total_monitors) AS "%"
FROM
(SELECT
monitor_width,
monitor_height,
COUNT(user_id) AS num_monitors
FROM
(SELECT
DISTINCT interaction_log.user_id,
monitor_width,
monitor_height
FROM
interaction_log,
monitor
WHERE
interaction_log.log_num = monitor.log_num AND
interaction_log.user_id IN (SELECT user_id FROM significant_users)) AS all_sizes
GROUP BY
monitor_width,
monitor_height
ORDER BY
monitor_width,
monitor_height
) AS per_user_monitor_counts,
(SELECT
COUNT(user_id) AS total_monitors
FROM
(SELECT
DISTINCT interaction_log.user_id,
monitor_width,
monitor_height
FROM
interaction_log,
monitor
WHERE
interaction_log.log_num = monitor.log_num AND
interaction_log.user_id IN (SELECT user_id FROM significant_users)) AS all_sizes
) AS total_monitor_counts
</query>
<view type="table" caption="Monitor Size Counts"/>
Monitor Size Counts| Width | Height | n | % |
|---|
| 768 | 1024 | 2 | 1.0 |
| 800 | 600 | 9 | 3.0 |
| 900 | 1440 | 1 | 0.0 |
| 1024 | 768 | 53 | 20.0 |
| 1024 | 1280 | 1 | 0.0 |
| 1152 | 864 | 9 | 3.0 |
| 1280 | 768 | 3 | 1.0 |
| 1280 | 800 | 27 | 10.0 |
| 1280 | 960 | 5 | 2.0 |
| 1280 | 1024 | 79 | 30.0 |
| 1360 | 1024 | 1 | 0.0 |
| 1400 | 1050 | 3 | 1.0 |
| 1440 | 900 | 18 | 7.0 |
| 1600 | 1024 | 1 | 0.0 |
| 1600 | 1050 | 1 | 0.0 |
| 1600 | 1200 | 16 | 6.0 |
| 1680 | 1028 | 1 | 0.0 |
| 1680 | 1050 | 22 | 8.0 |
| 1920 | 1080 | 1 | 0.0 |
| 1920 | 1200 | 11 | 4.0 |
This form gives you a chance to modify the query and quickly see
the results but it does not update the wiki page..
<query>
SELECT
num_monitors AS "Number of Monitors",
per_user_monitor_count AS "Monitor Count",
ROUND(per_user_monitor_count * 100.0 / total_monitor_count) AS "%"
FROM
(SELECT
num_monitors,
COUNT(num_monitors) AS per_user_monitor_count
FROM
(SELECT
MAX(monitor_num)+1 AS num_monitors
FROM
interaction_log,
monitor
WHERE
interaction_log.log_num = monitor.log_num AND
interaction_log.user_id IN (SELECT user_id FROM significant_users)
GROUP BY
interaction_log.user_id) AS num_monitors_per_user_table
GROUP BY
num_monitors
ORDER BY
num_monitors
) AS monitor_count,
(SELECT
COUNT(num_monitors) AS total_monitor_count
FROM
(SELECT
MAX(monitor_num)+1 AS num_monitors
FROM
interaction_log,
monitor
WHERE
interaction_log.log_num = monitor.log_num AND
interaction_log.user_id IN (SELECT user_id FROM significant_users)
GROUP BY
interaction_log.user_id) AS num_monitors_per_user_table
) AS total_monitor_count_table
</query>
<view type="table" caption="Number of Monitors Summary"/>
Number of Monitors Summary| Number of Monitors | Monitor Count | % |
|---|
| 1 | 180 | 85.0 |
| 2 | 32 | 15.0 |
