Hi,
I want to show my data as a MSStepline Chart in a timeline.
I have for each date 3 values taht I want to show.
When I use "SELECT 'dbr.chart.options', 'datetimescale', 1;" it shows the right distance between the dates, but the x-axis values are always the first of the month.
If I don't use datetimescale option it shows me the date values from my sql query.
I want to use datetimescale and also see the dates from syl in my x-axis. Is that possioble? and how?
Here my query:
select UK.StartDatum as Datum, 'Bruttolohn', UK.Bruttolohn
from ITRONIC.user AS U
LEFT JOIN ITRONIC.user_karriere AS UK ON UK.User = U.ID
where U.ID = in_user
UNION ALL
select UK.StartDatum as Datum, 'Lohn im Verhältnis', UK.Bruttolohn / (UK.Sollstunden * 5 ) * 40
from ITRONIC.user AS U
LEFT JOIN ITRONIC.user_karriere AS UK ON UK.User = U.ID
where U.ID = in_user;