Student activity graph

[rotimi-best]

Feature Description

• We should track activities of students and display a graph on their dashboard.

Activities like:

1. Completed lesson
2. Submitted exercise
3. Community post
4. Community response
5. Newsfeed post
6. News feed response
7. Live comment
8. Live poll

Use Case

No response

Proposed Solution

No response

Alternatives (optional)

No response

Additional Context

No response

Please check the boxes that apply to this feature request.

• I have searched the existing feature requests to make sure this is not a duplicate.
• I have provided a detailed description of the requested feature.
• I have explained the use case or scenario for this feature.
• I have included any relevant technical details or design suggestions.
• I understand that this is a suggestion and that there is no guarantee of implementation.

[github-actions]

Thanks for the issue, our team will look into it as soon as possible. If you would like to work on this issue, please wait for us to decide if it's ready. To claim an issue that does not have the "needs triage" label, please leave a comment that says ".take". If you have any questions, please reach out to us on Discord or follow up on the issue itself.
For full info on how to contribute, please check out our contributors guide

[Raju-kadel-27]

@rotimi-best Can you assign this to me ?

[rotimi-best]

@Raju-kadel-27 Sure.

Curious how you'd like to implement it.

[Raju-kadel-27]

@rotimi-best Currently, I have not explored the codebase yet . Would be much easier if you provide me some insights about the issue.

[rotimi-best]

@Raju-kadel-27
Yeah sure I get it. I am more curious on a high level, how you would implement the data structure of the graph and a simple API to collect the data.

Implementing this feature would be a great advantage to the platform.

I am thinking you don't really even need to understand how the app works works, you just need to implement an endpoint in our backend to collect the data, store it and render this student graph

[Raju-kadel-27]

@rotimi-best we need to think scalability in mind right ? Will come back to you after some research.
If you have any pre-planned ways, you can share it to me ?

[rotimi-best]

@Raju-kadel-27 Yes.

Ideally some event driven system we could use to collect the data, store it the db and a GET endpoint that is cached to handle API requests.

It would be cool if we could also keep track of the activities of the students that we can show in graphs or table format.

For example we can have a leaderboard of the most active student in an organization and in what course they belong to.

[rotimi-best]

Yes we are using supabase for our db.

Heard a lot of things about clickhouse however I would say we keep things simple. I have also heard about Tinybird as well however my issue with having extra services is the work self hosters have to go through to setup our app.

Let's do DB for now and if we face issues in the future can move it away from the DB to a dedicated service. What do you think?

[Raju-kadel-27]

@rotimi-best Yes, I think thats the best approach for now.