Aantal unieke gebruikers per tijdseenheid

je kan zelf de gewenste periode instellen door de data aan te passen:

/* You may need to use BB_BB60_STATS SCHEMA if searching for old dates */
SELECT COUNT(*)
  FROM (SELECT USER_PK1
          FROM BB_BB60.ACTIVITY_ACCUMULATOR a
         WHERE TIMESTAMP > TO_DATE('01/02/2007', 'DD/MM/YYYY')
            AND TIMESTAMP < TO_DATE('01/03/2007', 'DD/MM/YYYY')
           AND USER_PK1 IS NOT NULL
        GROUP BY a.session_id);
No feedback yet
Leave a comment

Your email address will not be revealed on this site.
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)
This is a captcha-picture. It is used to prevent mass-access by robots.
Please enter the characters from the image above. (case insensitive)
Trackback address for this post
This is a captcha-picture. It is used to prevent mass-access by robots.
Please enter the characters from the image above. (case insensitive)