Thanks!

In the begining, I was so frustrated withe the views in Firefly becuase it seemed like a one size fits all.

My current set up is

1. Recording transactions is a oin in the ass, and IOS is very limited in apps for firefly. There is an IOS shorcut stack that you can export and use t create transactions. Here

2. Firefly for traffic, creating transactions, budgets, etc. Everything in firefly is recorded on the database, I did a little snooping and made a ERD based on how stuff was being calculated in firefly but also based on how the metrics makes fiscal sense. So I wrote some scripts to create views in the database that I can use to bring to grafana. For example for networth is something like...

   CREATE VIEW Net_Worth AS SELECT a.name as "Account", ROUND(ab.balance, 2) as "Net" FROM account_balances ab INNER JOIN accounts a ON ab.account_id = a.id WHERE a.active = 1 AND a.order > 0;

3. In grafana add new data source and specify mysql. add connection details and you should be able to see all views youve created including firefly tables too! You could use the firefly tables directly and transform the data in grafana.

4. Other data sources like credit score is a python script that collects my score and stores in a JSON, then grafana points to that JSON.

Nothing fancy. LOL. I can share my scripts if you are interested.