How Do You Add "Number of Registered Users" to a Query?

Hi Shannon,

I am not 100% sure what your formula is for your calculation but here is a tactic I have used that is a lot easier than manually counting info.

Basically in Business Objects I created a new query where I pulled in all the data under the "Member" section to generate a master list of all users with their associated data.

Running the query and exporting as Excel you have a list of all users, when their account was created, when they first logged, when they last modified (seems to correlate to last login) and if their account is active (Active Member).

Using that data you could leverage some basic Excel date functions for week of year =weeknum(cell_of_desired_date_column) or month of year =month(cell_of_desired_date_column). There are dozens of ways to slice/dice the data but an easy one would be doing the month function on the Initial Login Datetime and filtering for the current year to get an understanding of how many folks logged on for the first time in that month.

You could also use the "modified datetime" field to figure out how many users have some activity for the current month. You can put that number over the total # of users who have ever logged in to calculate "active".

Personally, we have our instance set up so we get nightly database dumps and I'll pull my data out via SQL queries instead of playing around in Business Objects.

Hope this helps save some time,

Ryan