I forgot the new haf the table is moved out to balances out of accounts, so I was looking at rewards. Instead of 1300 HP, it should be this for all users onboarded in the last 12 months.
Top users being:
You are viewing a single comment's thread from:
wait... 11 users in 12 months?
you like practical jokes a lot, so are you serious?
The top is the sum of all.
Below is top users that were onboarding in the last 12 months based on their HP (> 500 HP)
I don't joke around about data.
Okay, so HP is higher, but I never paid attention to that bit.
Is this bit still the same?
PS. but it is only 11 users that hold more than 500 HP. We can call them 'effective contributor' or whatever fancy word we like to use.
all the user counts are accurate, the problem was balances was removed from accounts table in the new haf but there are hive/hbd fields which are actually rewards not balances. It's kind of weird. I am in the middle of moving all my queries over.