Hello everyone I am responsible for finances with my local students parliament(german homepage) and want to make fiscal data more transparent.
I already played around with openspendingjs and made this visualisation of our budget
openspending next looks really good so far but I don’t understand how to tell open spending that there are accounts that have sub accounts.I am especially interested in having a treemap
for example there is “goods and services” which is split up into several accounts , but there are also other accounts that don’t have subaccounts
my csv table used to look like this
table1
|account id |partent account | Account name | Amount | year |
|--------------|--------- ---------- | ------------------ |------------|------- |
|4.1| goods and services | phone and internet | 5000|2016
|4.1.1| phone and internet | phone | 2000|2016
|4.1.2| phone and internet | internet | 3000|2016
|4.2|goods and services | food | 1200|2016
then I did something like this
table2
|account id |top level | level 2 |level 3| Amount | year |
|--------------|--------- ---------- | ------------------ |------------|------- |
|4.1.1| goods and services| phone and internet | phone | 2000|2016
|4.1.2| goods and services| phone and internet | internet | 2000|2016
|4.2|goods and services | ---------empty-----------| food|1200|2016
|5|elections | ---------empty-----------| —empty-----|8000|2016
table2 somewhat works with openspendingjs but I don’t know how to talk to penspendingnext
in order to understand the file.
also I’d love to add more information as account description and the actual amount spent next to the planned account in the budget.
thank you for your time