Joystream / pioneer

Governance app for Joystream DAO
https://pioneerapp.xyz/
GNU General Public License v3.0
44 stars 69 forks source link

Financials Dashboard #46

Open bedeho opened 3 years ago

bedeho commented 3 years ago

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

History metrics

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

freakstatic commented 3 years ago

@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

mochet commented 3 years ago

Some ideas

@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.

freakstatic commented 3 years ago

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

bedeho commented 3 years ago

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 commented 3 years ago

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

freakstatic commented 3 years ago

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

mochet commented 3 years ago

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.

bedeho commented 3 years ago

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.

mochet commented 3 years ago

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:

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

bedeho commented 3 years ago

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

mochet commented 3 years ago

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.

bedeho commented 3 years ago

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.

blaxkspace commented 1 year ago

Hello

chrlschwb commented 1 year ago

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

blaxkspace commented 1 year ago

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

dmtrjsg commented 1 year ago

@blaxkspace

Suggested way to address the design issue:

blaxkspace commented 1 year ago

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

traumschule commented 1 year ago

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.

dmtrjsg commented 1 year ago

@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!

blaxkspace commented 1 year ago

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

bedeho commented 1 year ago

Fixed.

blaxkspace commented 1 year ago

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

msmadeline commented 10 months ago

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:)

dmtrjsg commented 10 months ago

@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.

msmadeline commented 9 months ago

@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

kdembler commented 9 months ago

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
msmadeline commented 9 months ago

@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 commented 9 months ago

@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

bedeho commented 9 months ago

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.

msmadeline commented 9 months ago

@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