I'd like to run a report that shows the growth in the number of users (instructors and students) over a 10 year period...I want a figure for each year. Please advise steps to find this information. Thanks!
Can you clarify how this should be measured?
Yes based on new accounts, even though we have purged on occasion.. I want to show the growth...
SELECT COUNT (uu.pk1) as "ACCOUNTS" ,TO_CHAR(uu.dtcreated, 'YYYY') as "YEAR_CREATED"FROM users uuGROUP by TO_CHAR(uu.dtcreated, 'YYYY')ORDER by TO_CHAR(uu.dtcreated, 'YYYY')
This will give you a count of users created in each year. Feel free to email me directly if you need more help. firstname.lastname@example.org
Retrieving data ...