Thank you for considering our product!
From the provided screenshots, I observe that the type of lead_created_on
is of type String
. I would recommend changing it to DateTime
. Overall, you have created the line chart correctly. The important for Start date
and End date
parameters is to set the Name
(DateTime), (default) Value
should be set to True
. From the third screenshot, I think that you added the parameters correctly. To be able to filter the table based on the parameters, you need to add 2 Filters to the Category Groups:
1) Mark the Line chart
2) From the Group explorer
-> Category Groups
-> Click on Filter
3) Add a filter to set the Start date:
4) Add a filter to set the
For the selection of the client, I would suggest an example which uses the client's name. You might want to change to the client's id. For the client's parameter, additionally, I would recommend setting AvailableValues
). Add one more filter for the client:
Please, find attached sample report which demonstrates the proposed approach.
If you use DateTime
values on the X axis you may consider using the DateTime Scale
for the axis. In this case it will be necessary to add X value to the lineSeries
(e.g. = Fields.Date). The difference with the Category Scale is that the latter will display only the dates that are present in the DataSource, and will not scale the dates proportionally along the axis. The DateTime scale will display all the dates between the minimum and maximum in the DataSource and will distribute the ticks on the axis proportionally, in equal time intervals.
Please, let me know if you need any additional help.
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