Graphing site sign-ups

I would like to graph a cumulative line graph of how many users have signed up for my site (e.g. 0 on day 1, sum of 10 on day 2, sum of 30 on day 3, etc). Where can that kind of information be found in Open edX databases?

Mysql openedx.auth_user

Thanks, that’s exactly what I was looking for.

Just to document the rest of the steps though for anyone else who wanders by, here’s how I got the data on a tutor system:

  • docker exec -it tutor_local_mysql_1 mysql -u root --password=password
  • mysql> use openedx;
  • mysql> SHOW VARIABLES LIKE “secure_file_priv”;
    • It was set to /var/lib/mysql-files/
  • mysql> SELECT id, date_joined FROM auth_user order BY date_joined FIELDS ENCLOSED BY ‘"’ TERMINATED BY ‘;’ ESCAPED BY ‘"’ INTO OUTFILE ‘/var/lib/mysql-files/reg_dates.csv’;
  • mysql> exit
  • docker container ls | grep mysql
    • Result was “3fea56790f15 mysql:latest …”
  • docker cp 3fea56790f15:/var/lib/mysql-files/reg_dates.csv data/

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.