Hledger charts

{"header":{"message":"hledger-vega/src as of git 2022-01-28 dd94a9e","description":null,"timestamp":"2022-01-31T17:55:11.338313Z","authors":[{}]},"hash":"IFCNRUJED6H45DCCO63OOFB2TDAXH6QBB6YP6NFOCDED5QVVLO5QC","authors":[{"login":"simonmichael","key":"BTcEaHew6zCVmzjGbxKrQdpx737x5Zt8b5LHrpC6qZdR"}],"deps":{"hashes":[["IFCNRUJED6H45DCCO63OOFB2TDAXH6QBB6YP6NFOCDED5QVVLO5QC","hledger-vega/src as of git 2022-01-28 dd94a9e"],["AA",null],["S67VKQH56OADLEAOQJBL4L756NWM5BDAFKYLE4MOAGEIHTG5GSYAC",""]],"deps":["S67VKQH56OADLEAOQJBL4L756NWM5BDAFKYLE4MOAGEIHTG5GSYAC"],"known":[]},"hunks":[{"FileAdd":{"meta":{"basename":"reports","metadata":576},"context":[{"change":2,"pos":1}],"contents":[]}},{"FileAdd":{"meta":{"basename":"wealth.report","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"assets;Total assets including retirement"},{"Add":"superannuation;Total assets including retirement"},{"Add":"assets;Total assets"},{"Add":"liabilities;Total liabilities"},{"Add":"loan;Loan"}]}},{"FileAdd":{"meta":{"basename":"wealth.json","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"{"},{"Add":" \"$schema\": \"https://vega.github.io/schema/vega-lite/v5.json\","},{"Add":" \"name\": \"Wealth\","},{"Add":" \"title\": {"},{"Add":" \"text\": \"Total wealth\","},{"Add":" \"subtitle\": \"Total assets and liabilities (thousand $)\""},{"Add":" },"},{"Add":" \"width\": \"container\","},{"Add":" \"height\": \"container\","},{"Add":" \"data\": { \"url\": \"../data/wealth.csv\"},"},{"Add":""},{"Add":" \"transform\": ["},{"Add":" { \"calculate\": \"datum.value / 1000\", \"as\": \"thousands\" }"},{"Add":" ],"},{"Add":""},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"encoding\": {"},{"Add":" \"x\": {"},{"Add":" \"field\": \"end_date\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"temporal\","},{"Add":" \"scale\": { \"domainMin\": { \"expr\": \"timeOffset('year', now(), -1)\" } }"},{"Add":" },"},{"Add":" \"y\": {"},{"Add":" \"field\": \"thousands\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"quantitative\","},{"Add":" \"aggregate\": \"sum\","},{"Add":" \"scale\": { \"zero\": false }"},{"Add":" },"},{"Add":" \"color\": {"},{"Add":" \"field\": \"account\","},{"Add":" \"type\": \"nominal\","},{"Add":" \"legend\": { \"title\": null, \"orient\": \"bottom\" }"},{"Add":" }"},{"Add":" },"},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"mark\": \"line\","},{"Add":" \"params\": [{ \"name\": \"grid\", \"select\": \"interval\", \"bind\": \"scales\" }]"},{"Add":" },{"},{"Add":" \"params\": [{"},{"Add":" \"name\": \"label\","},{"Add":" \"select\": { \"type\": \"point\", \"encodings\": [\"x\"], \"nearest\": true, \"on\": \"mouseover\" }"},{"Add":" }],"},{"Add":" \"mark\": \"point\","},{"Add":" \"encoding\": { \"opacity\": { \"condition\": { \"param\": \"label\", \"empty\": false, \"value\": 1 }, \"value\": 0 } }"},{"Add":" }"},{"Add":" ]"},{"Add":" },{"},{"Add":" \"transform\": [{\"filter\": {\"param\": \"label\", \"empty\": false}}],"},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"mark\": {\"type\": \"rule\", \"color\": \"gray\"},"},{"Add":" \"encoding\": {"},{"Add":" \"x\": {\"type\": \"temporal\", \"field\": \"end_date\", \"aggregate\": \"min\"}"},{"Add":" }"},{"Add":" },{"},{"Add":" \"encoding\": {"},{"Add":" \"text\": {\"type\": \"quantitative\", \"field\": \"value\", \"aggregate\": \"sum\", \"format\": \"$0.3s\"},"},{"Add":" \"x\": {\"type\": \"temporal\", \"field\": \"end_date\"},"},{"Add":" \"y\": {\"type\": \"quantitative\", \"field\": \"thousands\", \"aggregate\": \"sum\"},"},{"Add":" \"color\": {\"type\": \"nominal\", \"field\": \"account\"}"},{"Add":" },"},{"Add":" \"layer\": ["},{"Add":" { \"mark\": {\"type\": \"text\", \"align\": \"right\", \"dx\": -5, \"dy\": -5, \"strokeWidth\": 2, \"stroke\": \"white\"} },"},{"Add":" { \"mark\": {\"type\": \"text\", \"align\": \"right\", \"dx\": -5, \"dy\": -5} }"},{"Add":" ]"},{"Add":" }"},{"Add":" ]"},{"Add":" }"},{"Add":" ]"},{"Add":"}"}]}},{"FileAdd":{"meta":{"basename":"savings.report","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"expenses;expenses"},{"Add":"repayments;repayments"},{"Add":"revenue;revenue"},{"Add":"revenuesuper;revenuesuper"}]}},{"FileAdd":{"meta":{"basename":"savings.json","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"{"},{"Add":" \"$schema\": \"https://vega.github.io/schema/vega-lite/v5.json\","},{"Add":" \"name\": \"SavingsGoals\","},{"Add":" \"title\": {"},{"Add":" \"text\": \"Savings goals\","},{"Add":" \"subtitle\": \"Percentage of revenues put into savings, averaged over the last half year\""},{"Add":" },"},{"Add":" \"width\": \"container\","},{"Add":" \"height\": \"container\","},{"Add":" \"data\": { \"url\": \"../data/savings.csv\"},"},{"Add":""},{"Add":" \"transform\": ["},{"Add":" {"},{"Add":" \"window\": [{\"op\": \"sum\", \"field\": \"value\", \"as\": \"rolling_sum\"}],"},{"Add":" \"groupby\": [\"account\"],"},{"Add":" \"frame\": [-181, 0]"},{"Add":" },"},{"Add":" {"},{"Add":" \"window\": [{\"op\": \"count\", \"as\": \"window_size\"}],"},{"Add":" \"groupby\": [\"account\"],"},{"Add":" \"frame\": [-181, 0]"},{"Add":" },"},{"Add":" { \"filter\": \"datum.window_size >= 90\" },"},{"Add":" { \"pivot\": \"account\", \"groupby\": [\"end_date\"], \"value\": \"rolling_sum\" },"},{"Add":" {"},{"Add":" \"calculate\": \"datum.revenuesuper != 0 ? (datum.revenuesuper - datum.expenses) / datum.revenuesuper : 0\","},{"Add":" \"as\": \"Including superannuation\""},{"Add":" },"},{"Add":" {"},{"Add":" \"calculate\": \"datum.revenue != 0 ? (datum.revenue - datum.expenses) / datum.revenue : 0\","},{"Add":" \"as\": \"Savings\""},{"Add":" },"},{"Add":" {"},{"Add":" \"calculate\": \"datum.revenue != 0 ? (datum.revenue - datum.repayments) / datum.revenue : 0\","},{"Add":" \"as\": \"Liquid savings\""},{"Add":" },"},{"Add":" {\"fold\": [\"Savings\", \"Liquid savings\", \"Including superannuation\"], \"as\": [\"account\", \"value\"]},"},{"Add":" {\"calculate\": \"datum.value * 100\", \"as\": \"percentage\"}"},{"Add":" ],"},{"Add":""},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"encoding\": {"},{"Add":" \"x\": {"},{"Add":" \"field\": \"end_date\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"temporal\","},{"Add":" \"scale\": { \"domainMin\": { \"expr\": \"timeOffset('year', now(), -1)\" } }"},{"Add":" },"},{"Add":" \"y\": {"},{"Add":" \"field\": \"percentage\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"quantitative\""},{"Add":" },"},{"Add":" \"color\": {"},{"Add":" \"field\": \"account\","},{"Add":" \"type\": \"nominal\","},{"Add":" \"legend\": { \"title\": null, \"orient\": \"bottom\" }"},{"Add":" }"},{"Add":" },"},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"mark\": \"line\","},{"Add":" \"params\": [{ \"name\": \"grid\", \"select\": \"interval\", \"bind\": \"scales\" }]"},{"Add":" },{"},{"Add":" \"params\": [{"},{"Add":" \"name\": \"label\","},{"Add":" \"select\": { \"type\": \"point\", \"encodings\": [\"x\"], \"nearest\": true, \"on\": \"mouseover\" }"},{"Add":" }],"},{"Add":" \"mark\": \"point\","},{"Add":" \"encoding\": { \"opacity\": { \"condition\": { \"param\": \"label\", \"empty\": false, \"value\": 1 }, \"value\": 0 } }"},{"Add":" }"},{"Add":" ]"},{"Add":" },{"},{"Add":" \"transform\": [{\"filter\": {\"param\": \"label\", \"empty\": false}}],"},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"mark\": {\"type\": \"rule\", \"color\": \"gray\"},"},{"Add":" \"encoding\": {"},{"Add":" \"x\": {\"type\": \"temporal\", \"field\": \"end_date\", \"aggregate\": \"min\"}"},{"Add":" }"},{"Add":" },{"},{"Add":" \"encoding\": {"},{"Add":" \"text\": {\"type\": \"quantitative\", \"field\": \"value\", \"aggregate\": \"sum\", \"format\": \"0.1%\"},"},{"Add":" \"x\": {\"type\": \"temporal\", \"field\": \"end_date\"},"},{"Add":" \"y\": {\"type\": \"quantitative\", \"field\": \"percentage\", \"aggregate\": \"sum\"},"},{"Add":" \"color\": {\"type\": \"nominal\", \"field\": \"account\"}"},{"Add":" },"},{"Add":" \"layer\": ["},{"Add":" { \"mark\": {\"type\": \"text\", \"align\": \"right\", \"dx\": -5, \"dy\": -5, \"strokeWidth\": 2, \"stroke\": \"white\"} },"},{"Add":" { \"mark\": {\"type\": \"text\", \"align\": \"right\", \"dx\": -5, \"dy\": -5} }"},{"Add":" ]"},{"Add":" }"},{"Add":" ]"},{"Add":" }"},{"Add":" ]"},{"Add":"}"}]}},{"FileAdd":{"meta":{"basename":"netposition.report","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"netposition;Net position"},{"Add":"superannuation;Retirement"},{"Add":"netposition;Total"},{"Add":"superannuation;Total"}]}},{"FileAdd":{"meta":{"basename":"netposition.json","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"{"},{"Add":" \"$schema\": \"https://vega.github.io/schema/vega-lite/v5.json\","},{"Add":" \"name\": \"NetPosition\","},{"Add":" \"title\": {"},{"Add":" \"text\": \"Net position\","},{"Add":" \"subtitle\": \"Net position (thousand $)\""},{"Add":" },"},{"Add":" \"width\": \"container\","},{"Add":" \"height\": \"container\","},{"Add":" \"data\": { \"url\": \"../data/netposition.csv\"},"},{"Add":""},{"Add":" \"transform\": ["},{"Add":" { \"calculate\": \"datum.value / 1000\", \"as\": \"thousands\" }"},{"Add":" ],"},{"Add":""},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"encoding\": {"},{"Add":" \"x\": {"},{"Add":" \"field\": \"end_date\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"temporal\","},{"Add":" \"scale\": { \"domainMin\": { \"expr\": \"timeOffset('year', now(), -1)\" } }"},{"Add":" },"},{"Add":" \"y\": {"},{"Add":" \"field\": \"thousands\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"quantitative\","},{"Add":" \"aggregate\": \"sum\","},{"Add":" \"scale\": { \"zero\": false }"},{"Add":" },"},{"Add":" \"color\": {"},{"Add":" \"field\": \"account\","},{"Add":" \"type\": \"nominal\","},{"Add":" \"legend\": { \"title\": null, \"orient\": \"bottom\" }"},{"Add":" }"},{"Add":" },"},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"mark\": \"line\","},{"Add":" \"params\": [{ \"name\": \"grid\", \"select\": \"interval\", \"bind\": \"scales\" }]"},{"Add":" },{"},{"Add":" \"params\": [{"},{"Add":" \"name\": \"label\","},{"Add":" \"select\": { \"type\": \"point\", \"encodings\": [\"x\"], \"nearest\": true, \"on\": \"mouseover\" }"},{"Add":" }],"},{"Add":" \"mark\": \"point\","},{"Add":" \"encoding\": { \"opacity\": { \"condition\": { \"param\": \"label\", \"empty\": false, \"value\": 1 }, \"value\": 0 } }"},{"Add":" }"},{"Add":" ]"},{"Add":" },{"},{"Add":" \"transform\": [{\"filter\": {\"param\": \"label\", \"empty\": false}}],"},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"mark\": {\"type\": \"rule\", \"color\": \"gray\"},"},{"Add":" \"encoding\": {"},{"Add":" \"x\": {\"type\": \"temporal\", \"field\": \"end_date\", \"aggregate\": \"min\"}"},{"Add":" }"},{"Add":" },{"},{"Add":" \"encoding\": {"},{"Add":" \"text\": {\"type\": \"quantitative\", \"field\": \"value\", \"aggregate\": \"sum\", \"format\": \"$0.3s\"},"},{"Add":" \"x\": {\"type\": \"temporal\", \"field\": \"end_date\"},"},{"Add":" \"y\": {\"type\": \"quantitative\", \"field\": \"thousands\", \"aggregate\": \"sum\"},"},{"Add":" \"color\": {\"type\": \"nominal\", \"field\": \"account\"}"},{"Add":" },"},{"Add":" \"layer\": ["},{"Add":" { \"mark\": {\"type\": \"text\", \"align\": \"right\", \"dx\": -5, \"dy\": -5, \"strokeWidth\": 2, \"stroke\": \"white\"} },"},{"Add":" { \"mark\": {\"type\": \"text\", \"align\": \"right\", \"dx\": -5, \"dy\": -5} }"},{"Add":" ]"},{"Add":" }"},{"Add":" ]"},{"Add":" }"},{"Add":" ]"},{"Add":"}"}]}},{"FileAdd":{"meta":{"basename":"netliquid.report","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"liquidassets;Liquid assets"},{"Add":"liquidliabilities;Short-term liabilities"},{"Add":"netliquid;Net liquid assets"}]}},{"FileAdd":{"meta":{"basename":"netliquid.json","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"{"},{"Add":" \"$schema\": \"https://vega.github.io/schema/vega-lite/v5.json\","},{"Add":" \"name\": \"NetLiquid\","},{"Add":" \"title\": {"},{"Add":" \"text\": \"Liquid assets\","},{"Add":" \"subtitle\": \"Liquid assets, net liquid assets, and short-term liabilities (thousand $)\""},{"Add":" },"},{"Add":" \"width\": \"container\","},{"Add":" \"height\": \"container\","},{"Add":" \"data\": { \"url\": \"../data/netliquid.csv\"},"},{"Add":""},{"Add":" \"transform\": ["},{"Add":" { \"calculate\": \"datum.value / 1000\", \"as\": \"thousands\" }"},{"Add":" ],"},{"Add":""},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"encoding\": {"},{"Add":" \"x\": {"},{"Add":" \"field\": \"end_date\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"temporal\","},{"Add":" \"scale\": { \"domainMin\": { \"expr\": \"timeOffset('year', now(), -1)\" } }"},{"Add":" },"},{"Add":" \"y\": {"},{"Add":" \"field\": \"thousands\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"quantitative\","},{"Add":" \"aggregate\": \"sum\""},{"Add":" },"},{"Add":" \"color\": {"},{"Add":" \"field\": \"account\","},{"Add":" \"type\": \"nominal\","},{"Add":" \"legend\": { \"title\": null, \"orient\": \"bottom\" }"},{"Add":" }"},{"Add":" },"},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"mark\": \"line\","},{"Add":" \"params\": [{ \"name\": \"grid\", \"select\": \"interval\", \"bind\": \"scales\" }]"},{"Add":" },{"},{"Add":" \"params\": [{"},{"Add":" \"name\": \"label\","},{"Add":" \"select\": { \"type\": \"point\", \"encodings\": [\"x\"], \"nearest\": true, \"on\": \"mouseover\" }"},{"Add":" }],"},{"Add":" \"mark\": \"point\","},{"Add":" \"encoding\": { \"opacity\": { \"condition\": { \"param\": \"label\", \"empty\": false, \"value\": 1 }, \"value\": 0 } }"},{"Add":" }"},{"Add":" ]"},{"Add":" },{"},{"Add":" \"transform\": [{\"filter\": {\"param\": \"label\", \"empty\": false}}],"},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"mark\": {\"type\": \"rule\", \"color\": \"gray\"},"},{"Add":" \"encoding\": {"},{"Add":" \"x\": {\"type\": \"temporal\", \"field\": \"end_date\", \"aggregate\": \"min\"}"},{"Add":" }"},{"Add":" },{"},{"Add":" \"encoding\": {"},{"Add":" \"text\": {\"type\": \"quantitative\", \"field\": \"value\", \"aggregate\": \"sum\", \"format\": \"$0.3s\"},"},{"Add":" \"x\": {\"type\": \"temporal\", \"field\": \"end_date\"},"},{"Add":" \"y\": {\"type\": \"quantitative\", \"field\": \"thousands\", \"aggregate\": \"sum\"},"},{"Add":" \"color\": {\"type\": \"nominal\", \"field\": \"account\"}"},{"Add":" },"},{"Add":" \"layer\": ["},{"Add":" { \"mark\": {\"type\": \"text\", \"align\": \"right\", \"dx\": -5, \"dy\": -5, \"strokeWidth\": 2, \"stroke\": \"white\"} },"},{"Add":" { \"mark\": {\"type\": \"text\", \"align\": \"right\", \"dx\": -5, \"dy\": -5} }"},{"Add":" ]"},{"Add":" }"},{"Add":" ]"},{"Add":" }"},{"Add":" ]"},{"Add":"}"}]}},{"FileAdd":{"meta":{"basename":"incomestatement.report","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"expenses;Total expenses"},{"Add":"revenue;Total revenue"},{"Add":"repayments;Expenses and repayments"}]}},{"FileAdd":{"meta":{"basename":"incomestatement.json","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"{"},{"Add":" \"$schema\": \"https://vega.github.io/schema/vega-lite/v5.json\","},{"Add":" \"name\": \"IncomeStatement\","},{"Add":" \"title\": {"},{"Add":" \"text\": \"Income statement\","},{"Add":" \"subtitle\": \"Weekly revenues and expenses, rolling average over a two-week window ($)\""},{"Add":" },"},{"Add":" \"width\": \"container\","},{"Add":" \"height\": \"container\","},{"Add":" \"data\": { \"url\": \"../data/incomestatement.csv\"},"},{"Add":""},{"Add":" \"transform\": ["},{"Add":" {"},{"Add":" \"window\": [{\"op\": \"mean\", \"field\": \"value\", \"as\": \"rolling_mean\"}],"},{"Add":" \"groupby\": [\"account\"],"},{"Add":" \"frame\": [-13, 0]"},{"Add":" },"},{"Add":" { \"calculate\": \"datum.rolling_mean * 7\", \"as\": \"weekly\" },"},{"Add":" { \"calculate\": \"datum.weekly / 1000\", \"as\": \"thousands\" }"},{"Add":" ],"},{"Add":""},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"encoding\": {"},{"Add":" \"x\": {"},{"Add":" \"field\": \"end_date\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"temporal\","},{"Add":" \"scale\": { \"domainMin\": { \"expr\": \"timeOffset('year', now(), -1)\" } }"},{"Add":" },"},{"Add":" \"y\": {"},{"Add":" \"field\": \"thousands\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"quantitative\","},{"Add":" \"aggregate\": \"sum\""},{"Add":" },"},{"Add":" \"color\": {"},{"Add":" \"field\": \"account\","},{"Add":" \"type\": \"nominal\","},{"Add":" \"legend\": { \"title\": null, \"orient\": \"bottom\" }"},{"Add":" }"},{"Add":" },"},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"mark\": \"line\","},{"Add":" \"params\": [{ \"name\": \"grid\", \"select\": \"interval\", \"bind\": \"scales\" }]"},{"Add":" },{"},{"Add":" \"params\": [{"},{"Add":" \"name\": \"label\","},{"Add":" \"select\": { \"type\": \"point\", \"encodings\": [\"x\"], \"nearest\": true, \"on\": \"mouseover\" }"},{"Add":" }],"},{"Add":" \"mark\": \"point\","},{"Add":" \"encoding\": { \"opacity\": { \"condition\": { \"param\": \"label\", \"empty\": false, \"value\": 1 }, \"value\": 0 } }"},{"Add":" }"},{"Add":" ]"},{"Add":" },{"},{"Add":" \"transform\": [{\"filter\": {\"param\": \"label\", \"empty\": false}}],"},{"Add":" \"layer\": ["},{"Add":" {"},{"Add":" \"mark\": {\"type\": \"rule\", \"color\": \"gray\"},"},{"Add":" \"encoding\": {"},{"Add":" \"x\": {\"type\": \"temporal\", \"field\": \"end_date\", \"aggregate\": \"min\"}"},{"Add":" }"},{"Add":" },{"},{"Add":" \"encoding\": {"},{"Add":" \"text\": {\"type\": \"quantitative\", \"field\": \"weekly\", \"aggregate\": \"sum\", \"format\": \"$0.3s\"},"},{"Add":" \"x\": {\"type\": \"temporal\", \"field\": \"end_date\"},"},{"Add":" \"y\": {\"type\": \"quantitative\", \"field\": \"thousands\", \"aggregate\": \"sum\"},"},{"Add":" \"color\": {\"type\": \"nominal\", \"field\": \"account\"}"},{"Add":" },"},{"Add":" \"layer\": ["},{"Add":" { \"mark\": {\"type\": \"text\", \"align\": \"right\", \"dx\": -5, \"dy\": -5, \"strokeWidth\": 2, \"stroke\": \"white\"} },"},{"Add":" { \"mark\": {\"type\": \"text\", \"align\": \"right\", \"dx\": -5, \"dy\": -5} }"},{"Add":" ]"},{"Add":" }"},{"Add":" ]"},{"Add":" }"},{"Add":" ]"},{"Add":"}"}]}},{"FileAdd":{"meta":{"basename":"expensecategories.report","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"expensecategories;"}]}},{"FileAdd":{"meta":{"basename":"expensecategories.json","metadata":0},"context":[{"change":0,"pos":19}],"contents":[{"Add":"{"},{"Add":" \"$schema\": \"https://vega.github.io/schema/vega-lite/v5.json\","},{"Add":" \"name\": \"ExpenseCategories\","},{"Add":" \"title\": {"},{"Add":" \"text\": \"Expense breakdown\","},{"Add":" \"subtitle\": \"Amount per week ($)\""},{"Add":" },"},{"Add":" \"data\": { \"url\": \"../data/expensecategories.csv\"},"},{"Add":""},{"Add":" \"transform\": ["},{"Add":" { \"calculate\": \"split(datum.account, ':', 2)\", \"as\": \"accountpair\" },"},{"Add":" {"},{"Add":" \"window\": [{\"op\": \"mean\", \"field\": \"value\", \"as\": \"rolling_mean\"}],"},{"Add":" \"groupby\": [\"accountpair\"],"},{"Add":" \"frame\": [-13, 0]"},{"Add":" },"},{"Add":" { \"calculate\": \"datum.rolling_mean * 7\", \"as\": \"weekly\" }"},{"Add":" ],"},{"Add":""},{"Add":" \"facet\": {"},{"Add":" \"field\": \"accountpair.0\","},{"Add":" \"type\": \"ordinal\","},{"Add":" \"sort\": { \"op\": \"sum\", \"field\": \"weekly\", \"order\": \"descending\" },"},{"Add":" \"legend\": { \"title\": null }"},{"Add":" },"},{"Add":""},{"Add":" \"columns\": 2,"},{"Add":" \"resolve\": { \"scale\": { \"y\": \"independent\", \"color\": \"independent\" } },"},{"Add":""},{"Add":" \"params\": [{"},{"Add":" \"name\": \"grid\","},{"Add":" \"select\": \"interval\","},{"Add":" \"bind\": \"scales\""},{"Add":" }],"},{"Add":""},{"Add":" \"spec\": {"},{"Add":" \"width\": 750,"},{"Add":" \"height\": 190,"},{"Add":""},{"Add":" \"mark\": \"line\","},{"Add":" \"encoding\": {"},{"Add":" \"x\": {"},{"Add":" \"field\": \"end_date\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"temporal\","},{"Add":" \"scale\": { \"domainMin\": { \"expr\": \"timeOffset('year', now(), -1)\" } }"},{"Add":" },"},{"Add":" \"y\": {"},{"Add":" \"field\": \"weekly\","},{"Add":" \"title\": null,"},{"Add":" \"type\": \"quantitative\","},{"Add":" \"stack\": true"},{"Add":" },"},{"Add":" \"color\": {"},{"Add":" \"field\": \"accountpair.1\","},{"Add":" \"type\": \"nominal\","},{"Add":" \"legend\": { \"title\": null }"},{"Add":" }"},{"Add":" }"},{"Add":" }"},{"Add":"}"}]}},{"FileAdd":{"meta":{"basename":"index.html","metadata":0},"context":[{"change":2,"pos":1}],"contents":[{"Add":""},{"Add":" "},{"Add":" Hledger charts"},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":" "},{"Add":"

"},{"Add":"

"},{"Add":""},{"Add":" "},{"Add":" "},{"Add":""}]}},{"FileAdd":{"meta":{"basename":"hledger-vega","metadata":64},"context":[{"change":2,"pos":1}],"contents":[{"Add":"#!/bin/sh"},{"Add":""},{"Add":"umask 077"},{"Add":""},{"Add":"dir=\"$(mktemp -d \"${TMPDIR:-/tmp}/hledger-vega.XXXXXXXXXX\")\""},{"Add":"trap \"rm -r $dir\" EXIT"},{"Add":""},{"Add":"argsdir=./args"},{"Add":"reportdir=./reports"},{"Add":"outdir=./data"},{"Add":""},{"Add":"# initialize a semaphore with a given number of tokens"},{"Add":"open_sem(){"},{"Add":" mkfifo $dir/pipe-$$"},{"Add":" exec 3<>$dir/pipe-$$"},{"Add":" rm $dir/pipe-$$"},{"Add":" local i=$1"},{"Add":" for((;i>0;i--)); do"},{"Add":" printf %s 000 >&3"},{"Add":" done"},{"Add":"}"},{"Add":""},{"Add":"# run the given command asynchronously and pop/push tokens"},{"Add":"run_with_lock(){"},{"Add":" local x"},{"Add":" # this read waits until there is something to read"},{"Add":" read -u 3 -n 3 x && ((0==x)) || exit $x"},{"Add":" ("},{"Add":" ( \"$@\"; )"},{"Add":" # push the return code of the command to the semaphore"},{"Add":" printf '%.3d' $? >&3"},{"Add":" )&"},{"Add":"}"},{"Add":""},{"Add":"# Create the data directory if it doesn't exist"},{"Add":"mkdir -p \"$outdir\""},{"Add":""},{"Add":"# Use 4 jobs"},{"Add":"N=4"},{"Add":"open_sem $N"},{"Add":""},{"Add":"hledger_with_name() {"},{"Add":" local namewithext=\"$(basename \"$1\")\""},{"Add":" local name=\"${namewithext%.*}\""},{"Add":" hledger balance --output-format=csv --layout=tidy --daily @\"$1\" \\"},{"Add":" > \"$dir/$name.csv\""},{"Add":" if [[ $(wc -l < \"$dir/$name.csv\") -le 1 ]]; then"},{"Add":" >&2 echo \"Warning: hledger produced no output from \\\"$1\\\"\""},{"Add":" fi"},{"Add":"}"},{"Add":""},{"Add":"make_report() {"},{"Add":" local namewithext=\"$(basename \"$1\")\""},{"Add":" local name=\"${namewithext%.*}\""},{"Add":" local IFS=\";\""},{"Add":" local first=1"},{"Add":" while read -a line; do"},{"Add":" local csv=\"$dir/${line[0]}.csv\""},{"Add":" local label=\"${line[1]}\""},{"Add":" {"},{"Add":" if [[ $first -eq 1 ]]; then"},{"Add":" cat \"$csv\""},{"Add":" else"},{"Add":" tail -n \"+2\" \"$csv\""},{"Add":" fi"},{"Add":" } | sed -e \"s/^\\\"...\\\"/\\\"$label\\\"/\""},{"Add":" first=0"},{"Add":" done < \"$1\" \\"},{"Add":" > \"$outdir/$name.csv\""},{"Add":"}"},{"Add":""},{"Add":"for query in \"$argsdir\"/*.args; do"},{"Add":" run_with_lock hledger_with_name \"$query\""},{"Add":"done"},{"Add":""},{"Add":"wait"},{"Add":""},{"Add":"for report in \"$reportdir\"/*.report; do"},{"Add":" run_with_lock make_report \"$report\""},{"Add":"done"},{"Add":""},{"Add":"wait"}]}},{"FileAdd":{"meta":{"basename":"args","metadata":576},"context":[{"change":2,"pos":1}],"contents":[]}},{"FileAdd":{"meta":{"basename":"superannuation.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/cumulative.args"},{"Add":"^assets:.*retirement"}]}},{"FileAdd":{"meta":{"basename":"revenuesuper.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/change.args"},{"Add":"--invert"},{"Add":"^(revenue|income)"},{"Add":"not::taxes"}]}},{"FileAdd":{"meta":{"basename":"revenue.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/change.args"},{"Add":"--invert"},{"Add":"^(revenue|income)"},{"Add":"not::retirement"}]}},{"FileAdd":{"meta":{"basename":"repayments.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/change.args"},{"Add":"--alias=/^liabilities:(.*:loan.*)/=expenses:\\1"},{"Add":"^expenses"}]}},{"FileAdd":{"meta":{"basename":"netposition.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/cumulative.args"},{"Add":"^assets"},{"Add":"not:^assets:.*retirement"},{"Add":"^liabilities"}]}},{"FileAdd":{"meta":{"basename":"netliquid.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/cumulative.args"},{"Add":"^assets"},{"Add":"not:^assets:.*prepaids"},{"Add":"not:^assets:.*bonds"},{"Add":"not:^assets:.*retirement"},{"Add":"^liabilities"},{"Add":"not:^liabilities:.*loan"}]}},{"FileAdd":{"meta":{"basename":"loan.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/cumulative.args"},{"Add":"--invert"},{"Add":"^liabilities:.*loan"}]}},{"FileAdd":{"meta":{"basename":"liquidliabilities.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/cumulative.args"},{"Add":"--invert"},{"Add":"^liabilities"},{"Add":"not:^liabilities:.*loan"}]}},{"FileAdd":{"meta":{"basename":"liquidassets.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/cumulative.args"},{"Add":"^assets"},{"Add":"not:^assets:.*prepaids"},{"Add":"not:^assets:.*bonds"},{"Add":"not:^assets:.*retirement"}]}},{"FileAdd":{"meta":{"basename":"liabilities.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/cumulative.args"},{"Add":"--invert"},{"Add":"^liabilities"}]}},{"FileAdd":{"meta":{"basename":"import","metadata":576},"context":[{"change":0,"pos":18022}],"contents":[]}},{"FileAdd":{"meta":{"basename":"cumulative.args","metadata":0},"context":[{"change":0,"pos":19188}],"contents":[{"Add":"--historical"},{"Add":"--value=end,$"},{"Add":"--depth=0"}]}},{"FileAdd":{"meta":{"basename":"change.args","metadata":0},"context":[{"change":0,"pos":19188}],"contents":[{"Add":"--value=then,$"},{"Add":"--cost"},{"Add":"--depth=0"}]}},{"FileAdd":{"meta":{"basename":"expenses.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/change.args"},{"Add":"^expenses"}]}},{"FileAdd":{"meta":{"basename":"expensecategories.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/change.args"},{"Add":"--alias=/^expenses:([^:]*)$/=expenses:\\1:\\1"},{"Add":"--alias=/^expenses$/=expenses:uncategorised:uncategorised"},{"Add":"--depth=3"},{"Add":"--drop=1"},{"Add":"^expenses"}]}},{"FileAdd":{"meta":{"basename":"assets.args","metadata":0},"context":[{"change":0,"pos":18022}],"contents":[{"Add":"@import/cumulative.args"},{"Add":"^assets"}]}},{"FileAdd":{"meta":{"basename":"Makefile","metadata":0},"context":[{"change":2,"pos":1}],"contents":[{"Add":"all: vega vega-lite vega-embed"},{"Add":""},{"Add":"vegaVersion = 5"},{"Add":"vegaLiteVersion = 5"},{"Add":"vegaEmbedVersion = 6"},{"Add":""},{"Add":"vega: .FORCE"},{"Add":"\tcurl https://cdn.jsdelivr.net/npm/vega@$(vegaVersion) > vega@$(vegaVersion)"},{"Add":""},{"Add":"vega-lite: .FORCE"},{"Add":"\tcurl https://cdn.jsdelivr.net/npm/vega-lite@$(vegaLiteVersion) > vega-lite@$(vegaLiteVersion)"},{"Add":""},{"Add":"vega-embed: .FORCE"},{"Add":"\tcurl https://cdn.jsdelivr.net/npm/vega-embed@$(vegaEmbedVersion) > vega-embed@$(vegaEmbedVersion)"},{"Add":""},{"Add":".PHONY: all .FORCE"}]}},{"FileAdd":{"meta":{"basename":".ignore","metadata":0},"context":[{"change":2,"pos":1}],"contents":[{"Add":".git"},{"Add":".DS_Store"}]}}],"owner":"simonmichael","repo":"hledger-vega","token":"U9RtweT4A/MzSjU/m1RRV9/VGgRFXdtQLbUw5iGApDE=","login":null}

…

Dependencies

Change contents