pioneer icon indicating copy to clipboard operation
pioneer copied to clipboard

Financials Dashboard

Open bedeho opened this issue 4 years ago • 30 comments

Background

There needs to be a way for everyone to understand the economics on the platform, both currently, and in the past. This is an attempt at describing the key information that people will want to review to that end.

A very rudimentary economics overview exists in the current pioneer, however it does not have the ability to expose any complex information not already in the state, and it also is based on the runtime as it is now, not Olympia.

Financials

It should also be possible to perhaps export the raw data behind some of these with a single button click.

Designs

Most recent figma link: https://www.figma.com/file/GlgN8uBRtvtMJtiOsdtDF7/Pioneer-Design?node-id=4191%3A119416

Delivery

⚠️ PLS SEE LINKED CHILDREN GH ISSUES

State metrics

  • Total issuance
  • Total funds locked: here it would be good to know the breakdown of different reasons the funds are locked for, like validation, nomination, proposals, role in working group 1, role in working group 2, .... Importantly, since the same funds can be locked for more than one reasons, these numbers may exceed the total, but that is ok.
  • total reward debt across all groups
  • size of council budget
  • size of budget for group 1, 2, ...

History metrics

Over some period of time, e.g. in terms of a block interval, or interval of time, we may want to know

  • Total funds minted: here it would be goo to know the breakdown of different reasons
    • rewards for workers in group1,2,3
    • rewards for council
    • rewards for validators
    • spending proposals from council
    • spending from group 1,2,3,...
    • membership invitations
  • Number of missed reward payments across all working groups and council
  • Total value of all missed reward payments across all working groups and council
  • Total transaction fees.
  • Total funds burned: here it would be goo to know the breakdown of different reasons
    • buying memberships.
    • gateway cut: (this is a new thing coming)
    • proposal slashes
    • worker slashes
    • validator slashes

bedeho avatar Jan 21 '21 14:01 bedeho

@bedeho are you also thinking about including the history of the tokens spent in previous council rounds? I think would be interesting to see if the current council is spending more or less that the previous ones

freakstatic avatar Jan 21 '21 14:01 freakstatic

Some ideas

  • Total funds transferred between accounts in a given time period
  • Fees (fees seem to have disappeared from transactions, so maybe this is redundant)
  • Burned tokens from withdrawn/rejected/slashed proposals
  • Validator slashes
  • Forum transactions/Upload transactions (assuming these have some cost associated with them)

@bedeho are you also thinking about including the history of the tokens spent in previous council rounds? I think would be interesting to see if the current council is spending more or less that the previous ones

It may also be interesting to look at the history of tokens from different leads, this depends on how much control a lead has of spending on a working group though.

mochet avatar Jan 21 '21 15:01 mochet

Some ideas

  • Total funds transferred between accounts in a given time period
  • Fees (fees seem to have disappeared from transactions, so maybe this is redundant)
  • Burned tokens from withdrawn/rejected/slashed proposals
  • Validator slashes
  • Forum transactions/Upload transactions (assuming these have some cost associated with them)

@bedeho are you also thinking about including the history of the tokens spent in previous council rounds? I think would be interesting to see if the current council is spending more or less that the previous ones

It may also be interesting to look at the history of tokens from different leads, this depends on how much control a lead has of spending on a working group though.

Validator slashes would be a good addition but there haven't been much slashes lately so I think that this could have a low priority

freakstatic avatar Jan 21 '21 15:01 freakstatic

are you also thinking about including the history of the tokens spent in previous council rounds? I think would be interesting to see if the current council is spending more or less that the previous ones

So you mean being able to see a sort of metrics per council ? I did not think of that, but it sounds interesting.

bedeho avatar Jan 21 '21 16:01 bedeho

Great suggestions guys, have added a few that seem immediately feasible.

bedeho avatar Jan 21 '21 16:01 bedeho

are you also thinking about including the history of the tokens spent in previous council rounds? I think would be interesting to see if the current council is spending more or less that the previous ones

So you mean being able to see a sort of metrics per council ? I did not think of that, but it sounds interesting.

Yes it may help to better understand how the previous council round workout

freakstatic avatar Jan 21 '21 16:01 freakstatic

I think one issue I mentioned previously would apply to this page: https://github.com/Joystream/joystream/issues/1631

Obviously any historical data is somewhat hard to understand without some form of exchange rate as to show how much the tokens were worth at the time they were minted/burned/staked.

But that is a complex question with no immediate/obvious answer.

mochet avatar Jan 21 '21 18:01 mochet

Obviously any historical data is somewhat hard to understand without some form of exchange rate as to show how much the tokens were worth at the time they were minted/burned/staked.

Yeah that means you need some historical price feed, that's a little too complex for what we can aim at now.

bedeho avatar Jan 21 '21 20:01 bedeho

One thought on total issuance: we currently track total issuance, but its important to note this is total "active" issuance and excludes all burned tokens. I don't believe there is any way to currently track the total issuance (excluding burns).

For example on current testnet:

  • Total Active Issuance (including burns): 256163909 JOY
  • Total burns: ~83,400,000 JOY
  • Total Issuance (excluding burns): 339563909 JOY
  • % of issued tokens that are burned: 32.55%

On mainnet, there would probably be far less token burns, but I think this is still a valuable metric to have.

mochet avatar Jan 23 '21 08:01 mochet

Why would we want to track an issuance that includes burned coins?

bedeho avatar Jan 23 '21 08:01 bedeho

Why would we want to track an issuance that includes burned coins?

Because the total tokens issued (including burns) shows the commitment of minting those tokens to begin with. So for example, if we look at the current testnet with 256m tokens but 32.55% of tokens have been burned, it looks like a lot less tokens have been minted (either through validator rewards/spending proposals/role payments) than actually have.

Of course, since on the testnet we are burning tokens to exchange for BCH it creates a situation where the proportion of tokens burned... on mainnet I couldn't imagine it being this high, but it still may be significant if there are many failed/slashed proposals.

I'm not sure of all the scenarios on mainnet in which tokens would be burned, but they might add up after time and create a distorted view of what tokens were minted and then lost to burning (for whatever reason they are burned)

If for example, over time on mainnet, 5% of tokens are burned, I think its still important to show that the council/working groups/validators were responsible for minting those 5% of tokens in the first place, before they were burned.

mochet avatar Jan 23 '21 09:01 mochet

Ok yes I totally agree that we should create clarity in what was minted and what was burned, and also for what purpose, but I think in terms of issuance, which perhaps I should call "circulating supply" or something, that is a well defined thing that people expect to have a certain meaning.

bedeho avatar Jan 23 '21 10:01 bedeho

Hello

blaxkspace avatar Jan 25 '23 07:01 blaxkspace

I have hired blaxkspace for this design issue. Payment will be done via spending proposal to membership 4572 SpiceTank

chrlschwb avatar Jan 25 '23 07:01 chrlschwb

Wireframe will be ready by 2PM UTC+2 today 20230201 .

blaxkspace avatar Feb 01 '23 05:02 blaxkspace

@blaxkspace

Suggested way to address the design issue:

  • [ ] Conduct discovery interviews with target users of this feature: council members and WG Leads, some of the very involved founding members that could I could think of are @freakstatic @traumschule @kdembler

Verify the objective of the financials page, what are they trying to achieve ideally and how they are doing it right now, how often they use the interfaces and for what use cases

  • [ ] Take current designs of financials module and test it with the participants, to see where the presented solution is falling short of meeting their value (does it solve the problem) and usability (is information organised the way that is optimal for their needs) expectations
  • [ ] Create low fi mockups

Hand/ drawn are fine at this point, or low touch designs that only expose the information architecture on the page

  • [ ] Validate the low-fi designs with the technical lead on feasibility of implementation

@thesan will need to chime in on this as financials will heavily rely not only on pioneer but also Query Node tech constraints..

  • [ ] Refine the low-fi designs, taking into consideration technical constraints and feedback from users, and share for review with JSG team
  • [ ] Obtain confirmation and progress with the hi-fi designs relying on the components adopted in Pioneer already. In some cases feel free to suggest your own components if the design problem you are trying to solve is not currently covered with existing components.

dmtrjsg avatar Feb 02 '23 15:02 dmtrjsg

Will do - I've compiled your individual feedbacks/suggestions together in this file , please let me know if you'd like to add on to it before I begin work https://docs.google.com/document/d/1YzTCKtw1azfRhgNBwt4yfsgEdXSOm6EGlOp_c53xVk8/edit

@freakstatic @traumschule @kdembler @dmtrjsg Please let me know your discord IDs or alternatively drop a 'Hi' to my discord account:

SpiceTank | (GMT +2)#6128

ETA Feb 10

blaxkspace avatar Feb 03 '23 10:02 blaxkspace

The outgoing council just published a report with some stats and graphs as inspiration. The leaderboard table is another option to explore. Main deficit during a term is being able to tell minting per group and day to anticipate budgets.

traumschule avatar Feb 03 '23 10:02 traumschule

@blaxkspace feel free to reach out/ ask questions/ post intermittent updates in this chat: https://discord.com/channels/811216481340751934/1035125625482129448

My handle is dmtrmltsv and I can tag others in the chat 👍

Also, could you please add some comments or legend on how to read the markup used on the UX report page: https://docs.google.com/document/d/1nx2OQS4H2771idkQoF6rcoqrG3Xzgj4JBYykDsgu8QA/edit

Overall, great start! Curious about the results / insights from the discovery interviews, so looking forward!

dmtrjsg avatar Feb 03 '23 11:02 dmtrjsg

I don't have access to the channel #pioneer-design

Maybe someone could help me out here :)

As for the markup used , kindly disregard it as I'll be working from scratch again

blaxkspace avatar Feb 03 '23 16:02 blaxkspace

Fixed.

bedeho avatar Feb 04 '23 09:02 bedeho

Low Fidelity Prototype https://bit.ly/20230301JS1

Sketches https://discord.com/channels/811216481340751934/812344874099277824/1080575339387961365 https://discord.com/channels/811216481340751934/812344874099277824/1080575398426980423

Quick User Interview https://docs.google.com/document/d/1YzTCKtw1azfRhgNBwt4yfsgEdXSOm6EGlOp_c53xVk8/edit

Please let me know your feedback here or via DM ^.^ @SpiceTank | (GMT +2)#6128

blaxkspace avatar Mar 01 '23 19:03 blaxkspace

Interviewees

interviewed: Tomato, 0x2bc and Chaos77

User interviews

Before designing the financial dashboard I wanted to get a deeper understanding of users needs and insights in terms of finances. For that reason I conducted 3 in depth user interviews to gather all the information. All interviewees were people within DAO and had different roles in there. All of them will be potencial users of the financial dashboard.

Key findings

The following conclusions have not been prioritized in terms of importance.

➡1. Two users have their system of managing the data such as google sheets etc. that they consider unsufficient and hard to work with.

➡ 2. One of the most important matter for all users is to make projections of budget. They say that some desisions are made with a few month ahead of the time so they need to make analysis and forecast some events. They say that it would be great for them to understand the trends so If sth decreasses or increases, so that it helps them to make analysis and projections.

➡ 3. Most of users are saying that right now it’s hard to compare the financial data historically. They think that because of the fact that every council term has a different exchange rate we have to take it into account.

➡ 4. One user says that it’s important to have the information about how long the term lasted in a specific time. He said that there’s is a plan to change council period from 2 weeks to a month so this will make the financial data differ and should be presented in the dashboard.

➡ 5. All of the users want to be able to see how much tokens are being spent and burned in a council period among all of the working groups and also among all DAO.

➡ 6. All of the users want to see weekly salaries of workers and working groups.

➡ 7. One user says that it’s important for him to have the option to switch to spending “per term”(for example 15th term) or “per regular date”(for example 30th Oct 2023). He says that it would help to understand finances both for DAO members and leads as well as for “regular” people outside of the organisation.

➡ 8. All users want to see how much is being spent on a lead salary for a specific council term and how much the rest of a working group budget is.

➡ 9. One user want to see how many tokens are minted in a week and who minted them.

➡ 10. One user want to see how much is budget refiling price each day which would show how much the current council is managing it’s budget.

➡ 11. One user want to see how much budget the council have available to spend overtime.

Other interesting insights

💡 One user is saying that it would be interesting to see information like NFT sales or who is the highest payed worker, who is the lowest etc but these information are not crucial for him.

💡 One user would want to be able to see his own rewards historically and how much did he earn in joystream altogether. He also want to be able to compare his earnings historically.

@dmtrjsg @chrlschwb @bedeho Please let me know If there's is anything that you want to add or If you have some more questions to explore:)

msmadeline avatar Nov 07 '23 13:11 msmadeline

@msmadeline thank you for the summary. Great points there and most of them can and should be incorporated to the updated designs. Look forward to the low fidelity designs that build up on the latest version and taking into account the insights generated from your initial research.

dmtrjsg avatar Nov 10 '23 08:11 dmtrjsg

@dmtrjsg @chrlschwb Hello! I designed some low fidelity designs for the financial dashboard

Here's the link to the figma file ➡https://www.figma.com/file/p01HvVdf4wQiM80yFvLL63/Financial-Dahboard?type=design&node-id=111-11228&mode=design&t=oZx1Kou7cuB726Oh-4

Loom walkthrough's (I had a little trouble with loom so I had to do 2 videos) : 🎥Dashboard Current page: https://www.loom.com/share/d3f635371fba4fbca442e94ff23324ce?sid=dbd23cae-e5f0-458a-811c-805ff972ce6f 🎥Dashboard History page: https://www.loom.com/share/1b20c3c563ae4716b28391af1ec2879c?sid=a8dcd152-9055-4b19-8cb5-665487cbe91f

msmadeline avatar Nov 21 '23 12:11 msmadeline

Hi @msmadeline @chrlschwb some comments from my side:

Current page:

  1. I don't think we need JOY/USDT price on every chart. I think it's fine to have it on top of the page but including it in every chart doesn't add any value IMO
  2. I don't understand the difference between "DAO budget and spending" and "Council budget and spending" sections. Wouldn't those be the same?
  3. Likewise, I'm not sure I understand the "Tokens locked" section. In the mockups it displays locks for different WGs but WGs don't have any locked tokens. What's the idea behind this section, what kind of locks do we plan to display?
  4. In the "Working group" details section, the "Issues done" column only makes sense for BWG I think

History page:

  1. Question about "Minted rewards for working groups" and "Minted spending from working groups" sections - do I understand correctly that the first one would be total of budget refills for specific WG and then the second one the total spending of specific WG? The first one is useful but not sure about the second one, over the entire history, the spending will be very close to the refills value.
  2. Not sure what "Remaining minted funds" is supposed to represent
  3. I'm not sure about usefulness of "Number of missed reward payments", "Total value of all missed payments" and "Total reward debt". Since the debt goes away automatically once the WG budget is refilled, those won't be very helpful IMO

kdembler avatar Nov 22 '23 10:11 kdembler

@kdembler Thank you sir for this valuable feedback, I will definetely take it into account.

Current page:

  1. I included it just because some of the DAO members that I intervied told me that the joy exchange rate is important when you are looking at the data that happened some time ago and for example you want to compare it to the current date. I agree with you that maybe it can be too much so let me know what do you think about that concept after my explanation.
  2. Yes, I think I misunderstood something and that has to change for sure. @chrlschwb left a comment that maybe changing it to "Token Minting" or something like that can be more suitable. Wdyt?
  3. To be honest I'm still figuring out what exact data to display. I think that maybe we can leave everything exept of the Working groups. But I was doing it according to what Bedeho said in this issue. Maybe you know what data should I add here in the chart?
  4. Yep @chrlschwb also said that. I'm gonna design another example of that card for different working groups. I just need to find out about the specific differences between them.

History Page:

  1. That's a vey interesting information thank you, I actually didin't know that.
  2. So what I meant by this section is I wanted to display all the funds that has been minted but wasn't related to the working groups. Let me know If mybe I should change it for something else so it could be more clear to understand. Maybe you have some ideas.
  3. That's a great point, I didin't know that. I think that maybe I should just delete it.

msmadeline avatar Nov 22 '23 16:11 msmadeline

@dmtrjsg @chrlschwb @kdembler Hello! I implemented some feedback and created exploration 2 of the low fidelity financial dashboard

Here's the link: ➡ Dashboard Current page: https://www.figma.com/file/p01HvVdf4wQiM80yFvLL63/Financial-Dahboard?type=design&node-id=149-1056&mode=design&t=ayVUX4IAAo8nDFk6-4 ➡ Dashboard History page: https://www.figma.com/file/p01HvVdf4wQiM80yFvLL63/Financial-Dahboard?type=design&node-id=149-2227&mode=design&t=ayVUX4IAAo8nDFk6-4 ➡User story: https://www.figma.com/file/p01HvVdf4wQiM80yFvLL63/Financial-Dahboard?type=design&node-id=172-1948&mode=design&t=ayVUX4IAAo8nDFk6-4

Loom walkthrough: 🎥https://www.loom.com/share/ad34432463bb4e48b39732592d229d4c?sid=17c347fb-16f3-44fc-a8de-fcd1450a038d

msmadeline avatar Nov 24 '23 16:11 msmadeline

I have not followed this thread or reviewed any designs, I just want to highlight that I'm going to be submitting a proposal for some related features in Pioneer and the DAO, so to the extent shipping this is not extremely time sensitive (which I believe it's not), I hope everyone can just hang on before this goes into development.

bedeho avatar Nov 24 '23 18:11 bedeho

@chrlschwb Hello! I designed the first high fidelity version of the financial dashboard.

➡Figma link - https://www.figma.com/file/p01HvVdf4wQiM80yFvLL63/Financial-Dahboard?type=design&node-id=314-13603&mode=design&t=W24pJH9r6x9YpZ24-4

🎥Loom walkthrough - https://www.loom.com/share/528531b3db6d45df887191c77ba2cb5b?sid=2235ab7b-4b70-4722-b0c3-e09a8b81f160

msmadeline avatar Dec 07 '23 17:12 msmadeline