Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Unanswered: OLAP - Uniqueness for the quarter

    Hi All,

    We are encountering problems with quater count of records.

    Uniqueness is accurate for month; not if you aggregate for quarter or year; for example, user is active in Jan, Feb and Mar – The system would accurately show 1 active user for each of these months, but would show 3 active users for the 1st quarter (doesn’t recognize that it’s the same unique user).

    We want to count the active user only once for that quarter.

    Is the way to count that active users only once for that quarter instead three times. Please help and your input is appreciated.

    Thanks and have a nice day.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Use this format for your count:

    Select Count(Distinct UserID)
    From YourTable
    Where...........

    blindman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •