Graph Not to Show when Value =0 or No Data

3 posts, 0 answers
  1. Bryan Doan
    Bryan Doan avatar
    14 posts
    Member since:
    May 2010

    Posted 08 Nov 2010 Link to this post

    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. Peter
    Admin
    Peter avatar
    1611 posts

    Posted 11 Nov 2010 Link to this post

    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
  3. DevCraft banner
  4. Bryan Doan
    Bryan Doan avatar
    14 posts
    Member since:
    May 2010

    Posted 11 Nov 2010 Link to this post

    Hi Peter,

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

Back to Top