[Graph] Adding a default x0 value

[Mark]

I would like to add a gap in the graph based on my first series.

My data are in DateTime Scale so if my first series x0 value is e.g. 30.11.2019 next label steps are 30.12.2019, 30.01.2020 etc.

I want to set the x0 value to 01.11.2019 when my first series x0 value is 30.11.2019, 01.12.2019 when my first series of data is 11.12.2019 etc.

I notice there are 'maximum' and 'minimum' fields in label's properties but I can only enter there static date like 01.01.2010...

I would like to add there an expression: ' = "01/"+First(Fields.StartDate.Month)+"/"+First(Fields.StartDate.Year) ' but in response I show warning "Propery value is not valid".

Is there any way to solve my problem?

 

[Mark]

I'm attaching an example of this.

[Mark]

I would like to correct my first post. I don't want to change x0 value, just x0 LABEL.

[Neli]

Hello Grzegorz,

If I understood correctly, you want to display always the first day of the month on the  Date Time Scale axis (e.g. 01.01.2010 instead of 30.01.2010). You can set the Date Time Scale axis -> Scale -> BaseUnit property to Months. It will define the interval between the points on the axis based on the first day of the month. You may also want to set PossitionMode property to OnTicks. Check the attached report where the approach is demonstrated. 

Setting 'maximum' and 'minimum' values of the graph properties can be achieved through Bindings of the Coordinate system. For additional information, visit How to: Use Bindings to Control the Coordinate System Properties article.

Regards,
Neli
Progress Telerik

[Mark]

That's not my case. 

I have 10 projects with start date and end date. When start date of first project is 26.09.2019 the graph's x axis start exactly in this day.

When Base Unit is set to Days and Label and Major Steps are Months, next steps are like 26.10.2019, 26.11.2019.

I want to change the x0 of the graph based on the earlier start date of the projects. For example one of my project starts 26.09.2019 and other later, I want to set x0 of the graph to 01.09.2019 (x0 data point is still 26.09.2019) and next label and major steps to months (01.10.2019, 01.11.2019). How to achieve this?

I was looking for binding for this but unfortunately I didn't find 'Maximum' or 'Minimum' property path in the edit bindings window.

Sorry for my vague description of the problem in the first post.

[Mark]

Oh my fault, I was searching bindings in Data of the graph not Coordinate Systems.

I see now there is XAxis.Scale.Minimum binding. I will try achieve this with selected binding.

[Mark]

Ok I solved my problem. I'm sharing the solution if anyone would have the same issue.

1. Order the data source query by StartDate ASC.

2. Add the 'XAxis.Scale.Minimum' binding in CoordinateSystems properties: '= Fields.StartDate.Month+"/01/"+Fields.StartDate.Year'

3. Set the Base Unit to Days and Major and Label Units to Months. (XAxis->Scale)