[MyMeta] Weekly & monthly leaderboard filters

[peth-yursick]

What would you like to be added?

An ability to filter players on weekly & monthly periods.

Why is this needed?

Would allow us to highlight player of the week & player of the month.
Would make the leaderboard more dynamic in general & allow us to add "move" indicators to further gamify it as it would be easier for people to climb it.

With this one too, we have a lot more important things to take care of first but it would be good to keep in mind for future features.

[smitgol]

How we can filter player on weekly or monthly basis ? is there any data field in players data.

[dysbulic]

How we can filter player on weekly or monthly basis ? is there any data field in players data.

@smitgol, SourceCred's XP is stored in it's ledger according to weeks. I've not delved into the file structure that deeply, but my understanding is the ledger primarily holds the raw data & everytime you want to do a distribution the whole thing is calculated.

We could cache XP values per week in Hasura and do the sorts of filtering @peth-yursick's describing, but it's tricky because past values aren't set but fluctuate over time.

@alalonde may be able to speak more knowledgeably to what's in the ledger.

[alalonde]

Yeah, at this point any calculation would need to be done on demand in-memory. After loading the graph, you'd have to look at the sourcecred API and see if there is some kind of temporal iteration functionality.

@dysbulic's proposed sync-to-neo4j project would make this pretty straightforward, amongst a whole new world of potential calculations.

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

Work has been started.

These users each claimed they can complete the work by 264 years, 1 month from now.
Please review their action plans below:

1) theosch has started work.

As far as I understand it's about adding another filter option to https://metagame.wtf/players. Let's call it 'PERIOD'. I'm going to add 4 options there, just in case: 'Last 7 days', 'Last 30 days', 'This week' and 'This month'.
If I understood the task correctly, I'm going to make it in one day.

Learn more on the Gitcoin Issue Details page.

[peth-yursick]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

Work has been started.

These users each claimed they can complete the work by 264 years, 1 month from now. Please review their action plans below:

1) theosch has started work.

As far as I understand it's about adding another filter option to https://metagame.wtf/players. Let's call it 'PERIOD'. I'm going to add 4 options there, just in case: 'Last 7 days', 'Last 30 days', 'This week' and 'This month'. If I understood the task correctly, I'm going to make it in one day.

Learn more on the Gitcoin Issue Details page.

Correct!
Some of this data also already exists on the XP leaderboard (this week, last week & last month), so would just need to be pulled in.

However, I would draw your attention in another direction if possible.
We are currently gearing up for the 1.0 release which is happening this week on the 8th 👀
This issue is not one of the issues for the release - but there are a bunch more that are extra incentivized through a bounty system besides our internal rewards system.

• The issue I would direct you towards: Calculate $ amounts & add to the patrons leaderboard #1361
• All 1.0 launch issues: https://app.dework.xyz/metagame-1/metagame-10-launch/view/board-l8k8jdel

[0xSero]

We have seasonal and total, I believe that's enough for what we're doing, closing unless there's an issue