Activity Tags

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_users AS "Number of Users",
      ROUND(num_users * 100.0 / total_num_users) AS "%"
    FROM
     (SELECT
        COUNT(DISTINCT user_id) AS num_users
      FROM
        interaction_log
      WHERE
        session_tags &lt;&gt; '' AND
        user_id IN (SELECT user_id FROM significant_users)
      ) AS num_users_using_tags_table,
      (
        SELECT
          COUNT(DISTINCT user_id) AS total_num_users
        FROM
          significant_users
      ) AS total_num_users_table

  </query>
  <view type="table"/>

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
        COUNT(session_tags) AS num_tags_per_user
      FROM
       (SELECT
          user_id,
          session_tags
        FROM
          interaction_log
        WHERE
          session_tags &lt;&gt; '' AND
          user_id IN (SELECT user_id FROM significant_users)
          GROUP BY
            user_id,
            session_tags
        ) AS user_tags_table
      GROUP BY
        user_id
  </query>
  <view type="hist" caption="Histogram for Number of Tags Used, For Users Who Have Used at Least 1 Tag"/>

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
      ROUND(AVG(num_tags_per_user)) AS "Mean",
      MEDIAN(num_tags_per_user) AS "Median",
      ROUND(STDDEV(num_tags_per_user)) AS "SD",
      MIN(num_tags_per_user) AS "Min",
      MAX(num_tags_per_user) AS "Max",
      COUNT(num_tags_per_user) AS "n"
    FROM
     (SELECT
        COUNT(session_tags) AS num_tags_per_user
      FROM
       (SELECT
          user_id,
          session_tags
        FROM
          interaction_log
        WHERE
          session_tags &lt;&gt; '' AND
          user_id IN (SELECT user_id FROM significant_users)
          GROUP BY
            user_id,
            session_tags
        ) AS user_tags_table
      GROUP BY
        user_id) AS tag_counts_per_user_table
  </query>
  <view type="table"/>

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
      user_tags_table.user_id AS "User ID",
      session_tags AS "Tags",
      log_count AS "Total Num Logs Contributed"
    FROM
       (SELECT
          DISTINCT user_id,
          log_num,
          session_tags
        FROM
          interaction_log
        WHERE
          session_tags &lt;&gt; '' AND
          user_id IN (SELECT user_id FROM significant_users)
          GROUP BY
            log_num,
            user_id,
            session_tags
        ) AS user_tags_table,
       (SELECT
          user_id,
          COUNT(log_num) AS log_count
        FROM
          interaction_log
        WHERE
          session_tags &lt;&gt; '' AND
          user_id IN (SELECT user_id FROM significant_users)
          GROUP BY
            user_id
        ) AS log_count_per_user
    WHERE
      log_count_per_user.user_id = user_tags_table.user_id
    GROUP BY
      user_tags_table.user_id,
      session_tags,
      log_count
    ORDER BY
      log_count DESC
  </query>
  <view type="table"/>

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
      user_tags_table.user_id AS "User ID",
      session_tags AS "Tags",
      log_count AS "Total Num Logs Contributed",
      commands AS "Commands Used"
    FROM
       (SELECT
          DISTINCT user_id,
          log_num,
          session_tags
        FROM
          interaction_log
        WHERE
          session_tags &lt;&gt; '' AND
          user_id IN (SELECT user_id FROM significant_users)
          GROUP BY
            log_num,
            user_id,
            session_tags
        ) AS user_tags_table,
       (SELECT
          user_id,
          COUNT(log_num) AS log_count
        FROM
          interaction_log
        WHERE
          session_tags &lt;&gt; '' AND
          user_id IN (SELECT user_id FROM significant_users)
          GROUP BY
            user_id
        ) AS log_count_per_user,
        (SELECT
          log_num,
          array_accum(command_name) AS commands
        FROM
          (SELECT
            DISTINCT log_num,
            command_name
          FROM
            event_record,
            command_names
          WHERE
            event_record.command_id = command_names.command_id AND
            event_record.log_num IN (SELECT log_num FROM significant_logs)
              GROUP BY
                log_num,
                command_name
            ) AS commands_in_logs
          GROUP BY
            log_num
        ) AS commands_per_log
    WHERE
      log_count_per_user.user_id = user_tags_table.user_id AND
      user_tags_table.log_num = commands_per_log.log_num
    GROUP BY
      user_tags_table.user_id,
      session_tags,
      log_count,
      commands
    ORDER BY
      log_count DESC
  </query>
  <view type="table"/>