Financial tool, charts, tables and sum total amount

Help
,
1

What I’m trying to do

Quick background. I’m want to use obsidian as “financial status”, and I have problem with sum numeric values.

  1. Create dynamic list of items in table with values. for example:
  • Phone | 2k
  • Car | 10k
    …and more…
  1. Create Pie/Donut chart (I’m using for that chart plugin) where datasource is the table
  2. Sum total value of all items. And there I have problem

Things I have tried

  1. Dataview
    I find one solution in there that summary amount, but I do not find any way too use table block id as datasource in the dataviewjs.

  2. Advance Table
    Next way what I try, that use formulas in the advanced tables plugin, but I can not combine that with create an block ID below table. additionally this solution is not “dynamic” and require too click “calculate” after each change then I prefere kind of js solution

  3. Base on “field format”
    This is only solution should works but data source is not table, then I want to ask you if it only way to go :wink:

1 Like
2

What do you use to generate your dynamic lists? Is that Dataview already? If so, you could extend it to include some sums and stuff.

But you can’t currently get Dataview to use another static table or query as an input source.

What do you mean with field format? Is that something else than the advanced tables formulas?

3

Thanks for your reply!
Under “dynamic list” I mean kind of dataset that could be easily append in the feature. Later on outputs like char and total amount should works “dynamic”. So for I be honest I should say that is “list”. Now I use Markdown table for that, because this is kind of way to “feed” the chart like in this example

But yeah, I’m open to change that table for something else

“field format” is only name of the specific type of tag in the dataview but under that is normal tag with string that will later split using dataview (part of the “Total.md” file from “_work.zip” in this topic. But as you see, this solution is not very elegant as well.

Therefore I’m looking for kind of tool that’s allow me to do some operation on data. dataviewjs looks really cool, but I know that this plugin is not designed for this solution :confused:

1 Like