Home › forums › Using CanvasJS › Dynamic Charts using Database
Tagged: Dynamic multi series graphs
This topic contains 1 reply, has 2 voices, and was last updated by Vishwas R 8 months ago.
I have a table with roughly 75 columns and over 338,000,000 rows of data. These are readings that occur in 10 second intervals. I need a way to display various columns into a graph. I have a query to get the data and it displays in a GridView. I need a way though to get the ‘selected’ column values from the Gridview and display in a graph format. This will need to be a dynamic multi series chart that displays an 8 hour shift in 30 minute intervals. I am currently using asp.net (C#) to get the data; however, I have never made any graphs prior, especially like this, and don’t know how to proceed. Can someone please tell me how to get the column values displayed correctly? The user should have the ability to choose which columns he wants to graph (no more than 5).
You can render chart with data from html-table by reading entire column and by parsing it to the format accepted by CanvasJS.
Please take a look at this jsfiddle.
You must be logged in to reply to this topic.