This is a migrated thread and some comments may be shown as answers.

Graph report not displaying correct information

5 Answers 152 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mark
Top achievements
Rank 1
Mark asked on 13 Apr 2016, 11:53 AM

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,

5 Answers, 1 is accepted

Sort by
0
Ivan Hristov
Telerik team
answered on 14 Apr 2016, 10:25 AM

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
0
Mark
Top achievements
Rank 1
answered on 14 Apr 2016, 10:03 PM

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?

0
Ivan Hristov
Telerik team
answered on 15 Apr 2016, 10:59 AM
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
0
Mark
Top achievements
Rank 1
answered on 15 Apr 2016, 07:49 PM

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?

 

0
Ivan Hristov
Telerik team
answered on 18 Apr 2016, 07:49 AM
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
Tags
General Discussions
Asked by
Mark
Top achievements
Rank 1
Answers by
Ivan Hristov
Telerik team
Mark
Top achievements
Rank 1
Share this question
or