Graph/Hide date without value

2 posts, 0 answers
  1. Adrián
    Adrián avatar
    5 posts
    Member since:
    Sep 2018

    Posted 07 Jun Link to this post

    Hello,

    I have graph with Y axis (date) and i need hide date without values. It is possible?

     

     

  2. Neli
    Admin
    Neli avatar
    121 posts

    Posted 12 Jun Link to this post

    Hello Adrián,

    If you want to hide the dates with no values from the Graph item, you can apply Filtering to the Category groups which contain the date values. In the attached report, the following approach is demonstrated:
    1) There is a graph whose data comes from a CSV DataSource. It contains Date and Value columns. Some of the Values are empty.
    2) From the properties panel, navigate to Data -> Category Groups -> dateGroup -> Filters
    3) Set the new filter as follows:
    - Expression=IsNull(Fields.Value,-9999)
    - Operator: <>
    - Value: -9999

    Here instead of -9999, any value which does not exist in the datasource can be used. 

    Regards,
    Neli
    Progress 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