Incorrectly charted data.

While this is probably my error in configuration of the chart system, or not completely understanding the control.  Upload my problem, it connects to a url in the backend via ajax, (not a fan of DataManager).  Data is returned via that URL in JSON form.  The data is returned correctly yet the Chart doesn't render correctly in respect to DateTime.  Its exactly 1 on month off, as a result the charted data doesn't represent the pulled data.  The grid on the other hand is absolutely correct.  Also in the index.cshtml file is sample data from 1/1/2017 to 4/30/2017.  Data had to be filtered so I assumed the datasource could be universal source and filtered accordingly (this probably my error).

Do I need to fill each series via a push and a loop?

Morgan

Attachment: charterror_1c298b2b.zip

3 Replies

DD Dharanidharan Dharmasivam Syncfusion Team March 5, 2018 10:46 AM UTC

Hi Morgan, 

Thanks for using Syncfusion products. 

We have analyzed your query. From the provided screenshots and code snippet, we found that except one data(highlighted in the below screenshot), all the data has been rendered in chart.  

 

The reason for the data which is not rendered is that, since you have not filtered and assigned this data to chart. For your reference we have prepared a sample in which we have filtered the missed data, and now there will be five series in the chart. Find the screenshot below 

Screenshot for chart: 

 
Screenshot for grid data: 

 

Sample for reference can be find from below link. 
 
If your query is misunderstood at our end, kindly revert us with more information on your query which will be helpful in further analysis and provide you the solution sooner. 

Thanks, 
Dharani. 




MO Morgan March 6, 2018 07:30 AM UTC

Dharani,

Thanks, that helped immensely.  Realized the data has to be massaged slightly to make it work correctly with the data specifically the year and month, had to split the values coming from the server, and recreate based on associated month.  Also since I am still a javascript inept missed that months are Zero based, in JS.  Again thanks for the steerage.

Morgan


BP Baby Palanidurai Syncfusion Team March 7, 2018 09:26 AM UTC

Hi  Morgan, 

Thanks for your update, 

Please let us know, if you need any further assistance on this. 

Regards, 
baby 



Loader.
Up arrow icon