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.

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 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.