Very interested in buying wpDataTables to create charts. However, I have one doubt still. I'd like to be able to create charts with multiple series based on a database.
Database layout: columns X, Y, Z. with X=dates, Y=string, Z=value.
I would like to create a chart that creates series from all unique values in column Y (series Y1, Y2, Y3...) with on X-axis the dates from colum X and on Y-axis the values from column Z.
In the demo I can only get different columns to work as series, but this is not how many databases are organized?
The issue here is that you have two string-type columns (name and date), and chart engines we use do not support that. You can only use one string-type column to generate a chart.
So, unfortunately, you wouldn't be able to create a chart like this with wpDataTables.
Can i check what if i have 3 columns, key_id (integer), datetime and a value (integer)? Will i be able to generate a chart with multiple series based on the key_id as each series with their x: date time , y: value?
Can you share with me any resources to prepare a table of values to generate a line graph chart with 6 line series on a line chart.
I am a user of wpdatatables already and recently need to build a line chart with multiple data series (6) on the same chart.This is a sample csv file extracted from mysql. IT contains 6 distinct blockchain_id which represent the 6 different line series . I find very little info on the internet on how to generate multiple data series on a single chart using wpdatatable and i hope i can get some information in this thread.
Unfortunately, you will need to restructure this table, or create a custom SQL Query to build a new table showing that data, but creating custom queries is not included in the provided support for the plugin, so we wouldn't be able to help you with that.
Sometimes you will need to play around with the table's structure to display exactly what you want on the chart due to the chart engine limitation mentioned before.
Hi there,
Very interested in buying wpDataTables to create charts. However, I have one doubt still. I'd like to be able to create charts with multiple series based on a database.
Database layout: columns X, Y, Z. with X=dates, Y=string, Z=value.
I would like to create a chart that creates series from all unique values in column Y (series Y1, Y2, Y3...) with on X-axis the dates from colum X and on Y-axis the values from column Z.
In the demo I can only get different columns to work as series, but this is not how many databases are organized?
Just to clarify:
What I would want is to create a series "John" based on all rows with value "John" in the column 'names'.
Then another column 'date' (with date value) will be the X-axis and column 'score' (with float) will be Y-axis.
Table looks as following then:
------------------------------------------
Name | date | score
John | 13-10 | 7,4
Peter | 13-10 | 5,4
John | 13-10 | 6,7
-----------------------------------------
I then want a line graph with one line representing John and another representing Peter.
If this is possible, I'll happily purchase the product.
Hello Jasper
Thank you for your interest in wpDataTables.
The issue here is that you have two string-type columns (name and date), and chart engines we use do not support that. You can only use one string-type column to generate a chart.
So, unfortunately, you wouldn't be able to create a chart like this with wpDataTables.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Can i check what if i have 3 columns, key_id (integer), datetime and a value (integer)? Will i be able to generate a chart with multiple series based on the key_id as each series with their x: date time , y: value?
Can you share with me any resources to prepare a table of values to generate a line graph chart with 6 line series on a line chart.
I am a user of wpdatatables already and recently need to build a line chart with multiple data series (6) on the same chart.This is a sample csv file extracted from mysql. IT contains 6 distinct blockchain_id which represent the 6 different line series . I find very little info on the internet on how to generate multiple data series on a single chart using wpdatatable and i hope i can get some information in this thread.
Hi Farrell
Unfortunately, you will need to restructure this table, or create a custom SQL Query to build a new table showing that data, but creating custom queries is not included in the provided support for the plugin, so we wouldn't be able to help you with that.
Sometimes you will need to play around with the table's structure to display exactly what you want on the chart due to the chart engine limitation mentioned before.
Hi Blazenka,
Can you give me a sample data table containing multiple data series that can be used by wpdatatable to produce a line chart with multiple line series?
This will greatly allow me to understand and proceed to make any amendments in our private database for future work plans with wpdatatables .
Appreciate.
Hi Farrell
Unfortunately we do not have any samples to provide since this is not a standard plugin feature.
But we can recommend these services for customization:
https://codeable.io/?ref=l1TW1
https://wpkraken.io/?tms-plugins