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

Graph Not to Show when Value =0 or No Data

2 Answers 51 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Bryan Doan
Top achievements
Rank 1
Bryan Doan asked on 08 Nov 2010, 11:11 PM
Hello,

I have a graph with three series in it.  Each serie shows data from a column.  There are some months or all the months, depending on user selections, the data in one or all columns is 0.  How do I make the graphs not to show data when it is 0?  I tried to use IF in my calculated fields and put null if 0 and that worked but only worked when there's some data in the column, When the entire column had no data, an error "the column is not numeric" was thrown. 

Is there a way that not show the data when it is 0 even the entire column is 0? I just don't want the graph drops all the way to the bottom when 0.

Thanks!

2 Answers, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 11 Nov 2010, 05:26 PM
Hi Bryan Doan,

By default the numeric data types are not nullable, thus the chart series cannot accept null as a value. In order to achieve this kind of customization our suggestion is to filter your chart data with the Filter or if this is not applicable for your scenario you can create the chart programmatically and achieve greater flexibility.

Greetings,
Peter
the Telerik team
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 Public Issue Tracking system and vote to affect the priority of the items
0
Bryan Doan
Top achievements
Rank 1
answered on 11 Nov 2010, 10:03 PM
Hi Peter,

Thanks for the response!  I found a solution for my case!

Tags
General Discussions
Asked by
Bryan Doan
Top achievements
Rank 1
Answers by
Peter
Telerik team
Bryan Doan
Top achievements
Rank 1
Share this question
or