-
Re: How Do You Add "Number of Registered Users" to a Query?
jonswift Jun 10, 2010 10:36 AM (in response to shannon_marie)I do the same thing.
First I get the "registered users." For us that is someone who logged into the system once:
SELECT COUNT(*)
FROM JIVE.JIVEUSER
WHERE (LASTLOGGEDIN > 0)Then I look at the total number of users:
SELECT COUNT(*)
FROM JIVE.JIVEUSERDivide the registered by total and it gives us a view on the % of people who have logged into our Jive implementation.
-
Re: How Do You Add "Number of Registered Users" to a Query?
shannon_marie Jun 14, 2010 1:36 PM (in response to jonswift)Thanks so much for the response. I'm going to try plugging this in and see what happens. Fingers crossed!
Cheers!
-
Re: How Do You Add "Number of Registered Users" to a Query?
shannon_marie Jun 14, 2010 1:51 PM (in response to jonswift)Are you adding the commands you listed to the SQL? For some reason I'm not able to alter the SQL -- only the query.
Do you mind giving me a step-by-step of where you enter this?
Thanks!
-
Re: How Do You Add "Number of Registered Users" to a Query?
jonswift Jun 14, 2010 4:36 PM (in response to shannon_marie)What are you using to pull the data?
I'm using MS Visual Studio, but also use the SQL in Excel and a data analysis tool called Tableau.
-
Re: How Do You Add "Number of Registered Users" to a Query?
shannon_marie Jun 14, 2010 4:45 PM (in response to jonswift)Ahhh ... that explains the disconnect. I'm trying to get to the data using Business Objects.
I've submitted a support case, because I just can't get to the information. Thanks for your help!
-
Re: How Do You Add "Number of Registered Users" to a Query?
jonswift Jun 14, 2010 4:54 PM (in response to shannon_marie)Are you using the analytics module provided by Jive?
I haven't used Business Objects but if you can give me the version, etc. Perhaps, I can sift around the net and help you out.
Feel free to shot me an email if you'd like to share any screenshots.
-
Re: How Do You Add "Number of Registered Users" to a Query?
shannon_marie Jun 15, 2010 8:48 AM (in response to jonswift)I went ahead and posted an issue to my support team. They're coordinating directly with the BO developer, so I should have an answer soon.
Thanks for the offer of help, though -- especially since it's something you don't use yourself. MUCH appreciated.
Cheers!
-
Re: How Do You Add "Number of Registered Users" to a Query?
s_fariss Mar 8, 2011 11:34 AM (in response to shannon_marie)Shannon: Did you get an answer to this question from your support team? This is something I would be very interested in doing and I'm also trying it through the BusinessObjects interface.
-
Re: How Do You Add "Number of Registered Users" to a Query?
shannon_marie Mar 8, 2011 12:23 PM (in response to s_fariss)Honestly, Susan, I had a LOT of trouble getting a report that would give me this with any real accuracy. I was able to use a kind of formual hack to get it for the months prior -- something like new registrations - closed accounts was the closest way to get it, and even those numbers didn't totally add up as we approached the present timeframe.
What I've been doing since June when I ran into this issue is manually track the number of registered users each day via the UI browse > people. It's manual, yes, but it's the thing that's gotten me closest to an accurate count of restiered users over time. Early on, it seemed kind of pointless, but now I have 8+ months of daily registration counts that I can use where BO fails me.
-
Re: How Do You Add "Number of Registered Users" to a Query?
RyanSe Mar 11, 2011 12:30 PM (in response to shannon_marie)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
-
-
-
-
-
-
-
-