Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Show total number of participants (Station users) #154

Closed
Tracked by #152
, #167
...
bajtos opened this issue Aug 26, 2024 · 6 comments
Closed
Tracked by #152
, #167
...

Show total number of participants (Station users) #154

bajtos opened this issue Aug 26, 2024 · 6 comments
Assignees
@juliangruber

Comments

@bajtos
Copy link
Member

bajtos commented Aug 26, 2024

https://space-meridian.slack.com/archives/C07E0B56RKN/p1724177583985949

It would also be cool on the station website and dash to have the total number of FIL addresses to have ever submitted a measurement i.e. total user count

This should be very easy to implement:

  • We already have daily_participants table, the data is exposed via “daily active participants” and “monthly active participants” endpoints.
  • We can add another endpoint to expose the number of distinct participants over the entire history.
SELECT COUNT(DISTINCT participant_id) FROM daily_participants;

Count: 43,533
Query duration: 415ms
@bajtos bajtos mentioned this issue Aug 26, 2024
Closed
22 tasks
@patrickwoodhead patrickwoodhead mentioned this issue Oct 1, 2024
Closed
31 tasks
@bajtos bajtos changed the title Show total number of participants Show total number of participants (Station users) Oct 3, 2024
juliangruber added a commit to CheckerNetwork/spark-stats that referenced this issue Nov 13, 2024
@juliangruber
add GET /participants/summary
cab4c2a 
CheckerNetwork/roadmap#154
@juliangruber juliangruber mentioned this issue Nov 13, 2024
Merged
@juliangruber juliangruber self-assigned this Nov 13, 2024
@bajtos bajtos mentioned this issue Nov 20, 2024
Closed
26 tasks
juliangruber added a commit to CheckerNetwork/spark-stats that referenced this issue Nov 20, 2024
@juliangruber
Add GET /participants/summary (#248)
0cb6250 
* add GET /participants/summary

CheckerNetwork/roadmap#154

* fix responder

* fixes

* add caching

* refactor

* refactor `respondWithCaching`

* update function

* fix lint
@juliangruber
Copy link
Member

@patrickwoodhead where do we best surface this information?

@bajtos
Copy link
Member Author

bajtos commented Dec 2, 2024

Let's add it to our Public Station Dashboard: https://grafana.filstation.app/public-dashboards/2751d44f96914bb3a030b1de13224d19?orgId=1

@juliangruber
Copy link
Member

juliangruber commented Dec 2, 2024 •
edited
Loading

TODO:

@juliangruber
Copy link
Member

https://stackoverflow.com/questions/37917523/postgres-select-distinct-based-on-timestamp

@bajtos bajtos mentioned this issue Dec 2, 2024
Closed
15 tasks
@juliangruber
Copy link
Member

Added to the station dashboard as a total number:

Screenshot 2024-12-05 at 13 58 30

@juliangruber juliangruber mentioned this issue Dec 10, 2024
Merged
@juliangruber
Copy link
Member

https://grafana.filstation.app/public-dashboards/2751d44f96914bb3a030b1de13224d19?orgId=1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@juliangruber juliangruber

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@juliangruber @bajtos and others