Spending Trends sheet- Sankey Diagram available?

[HH22]

Couldn’t find mention of it anywhere but am curious if a Sankey Diagram add-in is available for the “Spending Trends” sheet? Better yet, perhaps it could be built in?

[bentyre1]

Hello,

I don’t think there’s a way to build one in but I have found the previous mentions of sankey charts in other threads that may be beneficial and worth taking a look at if that’s the way you’re interested in showing your data

Create a Cash Flow Sankey chart

Overview It uses Google Apps Script to generate a Sankey chart for cash flow based on your transactions in the Tiller Foundation Template. What is the goal of your workflow? What problem does it solve? Sankey is one of the most popular ways to compactly visualize flow-type information and it is a great fit for cash flow. It allows you to very quickly see if you have healthy cash flow and what your major in and out flows are. How did you come up with the idea for your workflow? Social media…

Expense visualization via sankey

Numbers removed. Some text blurred. The full diagram has all those details of course. [sankeymatic_20220127_102531_3000x4000] What is the goal of your workflow? What problem does it solve, or how does it help you? To get a big picture of how we spend our money and the relative spend across different categories. We did this for our 2021 budget/expense year to get a good view of where our money went and what we wanted to change/prioritize in 2022 How did you come up with the idea for your wor…

[YouBet96]

You should to be able to do this in Looker within Google. I have the free version of Google so I’m assuming you do as well within your Extensions menu. I just ran a prompt through ChatGPT and was able to create a Sankey diagram using Looker. I’m still messing with the display of the data because it’s not quite right, but I was able to build one pretty easily without using scripts like the older posts above.

[HH22]

Interesting. I haven’t used Looker but need to play around with it if it’s relatively simple to accomplish.

[twalane]

Interesting @YouBet96 ! Thanks for sharing that.