1 Answer, 1 is accepted
0
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
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