Add a new series in datetime(x-axies) line chart

Thread is closed for posting
6 posts, 0 answers
  1. Tairin Hahn
    Tairin Hahn avatar
    6 posts
    Member since:
    Jun 2012

    Posted 30 Dec 2009 Link to this post

    Hi, 

    I thought that telerik chart can support a series time graph. 
    (for example, x axis is date/time(YYmmDD HH:MM) and y axis is Temperature).
    Need to displace various room temperatures measured on the different time intervals in the same graph.
    (let say, I have a data for .. 

    Rm1.
    ___DATE____  __Temp__
    091229 09:00    70
    091229 10:00    71
    091229 12:00    74
    091229 13:00    72
    .     .
    .     .
    .     .

    Rm2.
    ___DATE____  __Temp__
    091229 09:10    73
    091229 10:20    74
    091229 12:30    77
    091229 13:20    76
    .     .
    .     .
    .     .


    Rm3.
    ___DATE____  __Temp__
    091229 09:15    72
    091229 10:10    73
    091229 11:30    76
    091229 13:20    76
    .     .
    .     .
    .     .

    Rm4.
    .      .
    .      .
    .      .

    my real data have less than 10mins various interval.  I need to display at least 6 month's information in one graph. 

    So, does RadChart can support this?? 
    I assumed that it can. But, I cannot be sure based on the evaluation version. 

    Thank you for your supports in advance.

  2. Schlurk
    Schlurk avatar
    812 posts
    Member since:
    May 2009

    Posted 30 Dec 2009 Link to this post

    You probably want to take a look at this demo, it shows how you can have dates on your y-axis :)
  3. Tairin Hahn
    Tairin Hahn avatar
    6 posts
    Member since:
    Jun 2012

    Posted 03 Feb 2010 Link to this post

    Hi,

    it works. but, it's really slow. (FYI, I attached the C# code.) 
    Once query has been submitted, it usually give a 7000 rows of data (for one device). It should handle at least 10 devices at one graph. Our current 3rd party chart tool can handle the same amount of data in decent amount of time and query itself took less than sec. But, with RadChart, it takes upto 2mins.

    We tested the same environment with current charting tool and radchart.One difference is that Radchart requires "foreach loop" of data to convert each datetime string althogh the other tool will take the datetime as it is (simply, binding it as table). 

    Can you suggest a better way to play with RadChart on datetime x-axis??
    Since other features of telerik product is very attractive, I need to improve this if possible to allow us to use telerik as our next generation tool.

    Thanks,
    """"""""""""""""""

    private

     

    void initialDrawChart(RadChart radchart)

     

    {

     

    System.Data.SqlClient.

    SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter("SOME REQUEST",

     

     

    ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

     

     

    DataSet zones = new DataSet();

     

    adapter.Fill(zones);

     

    ChartSeries s = radchart.Series[0];

     

     

    foreach (DataRow row in zones.Tables[0].Rows)

     

    {

     

    ChartSeriesItem item = new ChartSeriesItem();

     

     

    double temp = (double)row["VALUE"];

     

     

    DateTime dt = (DateTime)row["DATE"];

     

    item.YValue = temp;

    item.XValue = dt.ToOADate();

    s.Items.Add(item);

     

     

    }
    }

  4. Schlurk
    Schlurk avatar
    812 posts
    Member since:
    May 2009

    Posted 04 Feb 2010 Link to this post

    I believe this is the only way to display DateTime variables with the RadChart since you have to convert the date to a numerical (float in this case I believe) type before the chart can display it. If I read your description correctly you are attempting to bind 70,000 points of data to a single RadChart, which to me seems like it might be a good idea to try to reduce that number in order to increase performance.
  5. Tairin Hahn
    Tairin Hahn avatar
    6 posts
    Member since:
    Jun 2012

    Posted 04 Feb 2010 Link to this post

    Thanks for the fast response. =)

    We expect upto 70,000. But, currently it has been tested only for 7000 points. Do you have rough idea for number of points that expect to be handle by one Rad chart?
    We can filter or model the raw data. Still, rough number we aim to would be helpful.
    we have 1st tier environment for either hosting or developing web.   

    Thanks,
      
  6. Ves
    Admin
    Ves avatar
    2926 posts

    Posted 08 Feb 2010 Link to this post

    Hi Tairin,

    While the product was designed to be easily customizable and feature rich it does not cope well with extremely busy charts or rendering a lot of graphs on a single page. We are continually improving performance as we go but still the bottom line is that the control is targeted for casual situations which do not require a high performance solution. We would not recommend populating the chart with more than a thousand items, you can figure the exact number for the specific page according to your performance requirements.

    There is a trade off to make between high customization and high performance and we've gone the rich features path as it is what most of our customers are interested in.


    Regards,
    Ves
    the Telerik team

    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
    Follow the status of features or bugs in PITS and vote for them to affect their priority.
Back to Top