Include Categories in Analytics Endpoint #49
Description
We want to show the most used categories in our beta analytics dashboard
There is a bit of base work that needs to be done to first tackle this.
Requirements
- Currently the timeline generator aggregates the stats by schema. We need this updated to aggregate instead by platform. Platform is a field on both bounties and fulfillments. Right now we will have
bounties-networkandgitcoin.bounties-networkshould be the default if no schema is attached. - The endpoint should show each category name along with its total count for the timeframe
- This should be completed using django calls not raw sql. It should be a query on the fly and will need to aggregate the numbers by normalized_name
- The actual endpoint however needs to join with the RankedCategory model to get the prioritized name (as the normalized name can map to multiple names, RankedCategory has already done the proper mapping work to the human readable name).
Review
- Should correspond regularly and give an initial plan of action
- Key questions posted here
- Conversational and longer discussions should be directed to the bounties network slack in this channel
Qualifications
- This is a fairly advanced task, but the patterns are already in place. A good github history and good experience with python, django, SQL, docker are mandatory.
Deadline
- Please only take this issue if you have the capacity to work on this ACTIVELY over the next week. We'd like this finished quickly and do not want someone to take it who will passively work on it.
Before starting work, please communicate your plan and availability along with your intention to take the task. After initial communication, I'll approve the best candidate to take the task.