Hi Wix Experts
Can you please suggest a code example for creating a dynamic chart based on table data from collection?
For example - lest say that i have a table in my page that is connected to a collection, and that table has a filter that eventually presents 10 rows and few columns with data.
i want those 10 items values (from a relevant column) to show in a “dynamic” line chart.
Thanks,
Roy
Hi Roy,
You can find a an example here . For more chart styles, see here .
To obtain the records from the collection use getItems.
Hi Ido
There is a problem with the first link ( "example here " ) - it leads to a “Collapsing Form” example…
Hello Roy,
The chart example is available below
Hi Roy,
Check out this example for how to create a dynamic chart with data from a table.
Good luck!
Cheers,
Ben
Hi Roy. Did you manage to do this?. I’m looking to do the same thing. I have a weight and measurements database that I’m using to store client details .each time they weigh in I create a new item that has there new records in. The dataset on the page is filtered for their name in the weight measurement dataset to match the profile dataset name field. The profile dataset is filtered by owner. I want to display the Weight measurements dataset in the form of a line graph. But with the correct filters that are applied to the dataset on the page. I can’t seem to do it using thelinks
Oh my god, thank you for the link, it opens countless doors
If there is anyone who did the experiment
For graphical work and directly linked to the database
Be thankful to him for presenting the way to us
I did research and experiment as well but didn’t work with me
I hope the support team will develop a detailed explanation or example of the process of linking the graph directly with the database