Series on datavalue for the datafield?

[zippeurfouParticipant]

Hi,
I understand the topic name is not very easy to understand. Therefore, I’ll try to make it easy.
I’d like to have a dynamic number of series that are constructed from the value of my data.
Here is an example:
+————+—————–+————+
| type | sum(likesCount) | date |
+————+—————–+————+
| Free Coins | 7229 | 2014-03-01 |
| Other | 2826 | 2014-03-01 |
| NULL | NULL | 2014-04-01 |
| Free Coins | 103394 | 2014-04-01 |
| Free Spins | 29753 | 2014-04-01 |
| Other | 53380 | 2014-04-01 |
| NULL | NULL | 2014-05-01 |
| Free Coins | 136731 | 2014-05-01 |
| New Game | 7268 | 2014-05-01 |
| Other | 21682 | 2014-05-01 |
| NULL | NULL | 2014-06-01 |
| Free Coins | 41568 | 2014-06-01 |
| Free Spins | 11734 | 2014-06-01 |
| Other | 3958 | 2014-06-01 |
| NULL | NULL | 2014-07-01 |
| Free Coins | 45885 | 2014-07-01 |
| Free Spins | 21471 | 2014-07-01 |
| Other | 10778 | 2014-07-01 |
| Free Coins | 78294 | 2014-08-01 |
| Free Spins | 4540 | 2014-08-01 |
| Other | 36941 | 2014-08-01 |
+————+—————–+————+

I’d like the type ‘value’ to be my series (as many different series as there is different value for the field ‘type’: Free Coin, Free Spins, Other,NULL…), sum(likesCount) Y axis, date X axis.
I understand that I could parse this and create the proper structure but I was wondering if there was an option to specify a field value as my series entries.

Second question which is not related. Is it possible to hide a specific serie? If yes, how?

Thanks in advance!
Best,

[DimitarParticipant]

Hello zippeurfou,

I am afraid you would have to re-format your data to be able to load it successfully in jqxChart. You should have a record for each date and in it – data for all types, e.g.:

{ "date": "2014-03-01", "Free Coins": 7229, "Free Spins": null, "Other": 2826, "NULL": null }

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts