Graph report not displaying correct information

6 posts, 0 answers
  1. Mark
    Mark avatar
    3 posts
    Member since:
    Apr 2016

    Posted 13 Apr Link to this post

    I am demoing this software for replacement our current Microsoft Reporting platform.

    I am beginning with a simple trend report where we are plotting decimal values vs time.

    The result on the telerik graph is just a straight line.

    I need to show the variances along that line as is shown with the old graph from the Microsoft Reporting platform.

     

    Thank you,

  2. Ivan Hristov
    Admin
    Ivan Hristov avatar
    85 posts

    Posted 14 Apr Link to this post

    Hello Mark,

    We do not have enough information about the data your report uses and report structure, but we can give you some suggestions that hopefully will help you solve your problem:

    - make sure you are supplying the correct data to the Graph item - the easiest way to check this is to connect your data source to a Table item and see the data output.

    - it seems that you are using a DateTime scale on your X axis. Please check that the BaseUnit and MajorUnit properties are correctly set.

    - use the GraphWizard to build your graph - it provides an UI to help you avoid the most common mistakes that can be done during designing.

    Here are some links that may come helpful:


    In case you still have problems creating your chart, please send us your report definition along with some sample data so we can check it on our side.

    Hope it helps.

    Regards,

    Ivan Hristov
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Mark
    Mark avatar
    3 posts
    Member since:
    Apr 2016

    Posted 14 Apr in reply to Ivan Hristov Link to this post

    Hello,

     

    I have walked through the wizards and still cannot achieve what I need.

     

    I just need to plot my Y-axis value (decimal number) vs X-axis value (Time)

     

    What do I need to do in order to send the report definition to you?

  5. Ivan Hristov
    Admin
    Ivan Hristov avatar
    85 posts

    Posted 15 Apr Link to this post

    Hi Mark,

    We are trying to keep our wizards and documentation as useful as possible, so it will be of a great help to us if you describe at which step/page you had troubles to figure out what to do.

    Please take a look at the attached .trdx file that shows how to create a report, very similar to the one you are trying to produce. You can try it yourself:

    1. From the Insert tab of the Standalone Designer open the LineChart Wizard.

    2. The page "Choose data source" appears. If you already have a valid data source, select it. If you don't have a data source, setup it now. In our example we used a CSV DataSource with some sample data based on the screenshot you provided.

    3. The "Arrange graph fields" page appears. Drag the Time field to the Categories box and the Value field to the Values box.

    4. If your Time field is of a DateTime type, a page titled "Setup DateTime scale" appears. Select Hours for Label unit and Major unit. Select 3 for Label step and Major step. In our example we used 1 as a step because we didn't have that much data to show.

    5. Click Finish. Your chart is created and it looks very similar to the one you requested. Additionally you can set the Minimum and Maximum of your Y axis scale to 0 and 10 respectively and hide the legend and the title of your graph.

    If you still have troubles to setup your report, please send us your definition (either .trdx or .cs/.vb files) along with some sample data in a .zip file so we can help you further.

    Regards,
    Ivan Hristov
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  6. Mark
    Mark avatar
    3 posts
    Member since:
    Apr 2016

    Posted 15 Apr in reply to Ivan Hristov Link to this post

    Good afternoon,

     

    I have been working with the example report you had sent to me.

    I found that when I add more than 5000 rows of data, the app displays an error message about not able to display beyond 5000 labels for a tick mark.

    I am returning 86000 rows from my database.

    Is there another method beside the graph which may be a better fit?

     

  7. Ivan Hristov
    Admin
    Ivan Hristov avatar
    85 posts

    Posted 18 Apr Link to this post

    Hi Mark,

    The message you are seeing is to prevent you from creating an unreadable chart. As explained in Axis Validation section here, it actually says that the current settings of your scale will produce a chart with too many ticks or labels, making it virtually useless. It should be absolutely no problem to display hundreds of thousands of points with the Graph item, but you have to setup your axis properly.

    Please try the suggestions mentioned in Axis Validation article and see if they will solve your problem. As a start, we would recommend you to change the MajorUnit and MajorStep properties of your DateTime scale, showing a tick mark on every 2-3 hours or so. If needed, apply the same approach to the LabelUnit and LabelStep properties.

    If these properties should be dynamically set based on your data, you can achieve this using Bindings on your coordinate system. You can read more about this approach here:

    How to: Use Bindings to Control the Graph's Coordinate System Properties.

    Hope it helps.

    Regards,
    Ivan Hristov
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
DevCraft banner