I am trying to do something very simple that apparently is not immediate.
Let’s imagine I make a dataview query that fetches some data. This data represents different measurements (different units and meanings for large small etc). I would like to take this table and plot it in a line chart, or in multiple ones, in a fast way.
What I do is:
I make the dataview query
I copy paste the table into markdown (this is already annoying)
I add to it an ID to make it retrievable with the Charts plugin, say ^tablename
Even if I do this, I can only plot the graph as follows:
type: line
id: tablename
layout: columns
width: 80%
beginAtZero: false
which however inherits the units of measure of the first column. Namely, in my case my first column has only 20 or 0 as numbers, so all the other line graphs get plotted according to 20-0, with only two datapoints, while indeed the column is 8 rows times 7 fields, so I would like to plot 7 lines, with 8 values each.
It might be a better idea to use dataviewjs to execute the initial query, even if that is an ordinary dataview query, and then manipulate that data a little and render it as a graph from within the query. Here are three different threads discussing similar stuff: