nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Trouble with Chart Axis Label/Markerline

Chris605

Hi @all, I'm trying to find a solution for a milestone trend anlaysis chart. First some background informations:

I'm using a MySQL database as datasource. Within this database, i collect the milestones from MS Project. The dataset, which is used for the chart is a statement which reffers to this datasource.
For the chart, I've scripted a dynamic chart title. The dimension for the x- and y-Axis is defined by another script, which gets the date from MS Project (project start and finish date). It took a while to realize this, but until here, everything works as I wanted. If I now view the report, the last two entries on x-Axis are laying one upon the other. See attached file (Attechment1.jpg). Does anyone have an idea why? If I increase the stepsize from one to two months everything is fine...

The next problem I'm working on is the black "standard" line. Until now I realize this line with the help of a computed column. The values on x-Axis are the timestamp of milestone-entry creation in the MySQL database. The computed colum reads the value of this timestamp (e.g. 2010-06-10) and returns the first of the month (2010-06-01).

It's a solution which works, but now i want to realize this line with a marker line. Is there any possibility to define a line from the left lower corner to the right upper corner?(Attachment2.jpg) If yes, how to script this? I found some informations, how to script a line horizontally or vertically, but this isn't what I'm looking for.

Perhaps someone is working on the same issue and could share his/her experience. I'm thankful for any post and help. If we should find a solution, I'm going to share this with you..

Regards, Chris

Find more posts tagged with

Comments

mwilliams

Hi Chris,

What is your BIRT version?

For your first question, can you recreate this issue with the sample database?

For your second question, the computed column is the only way I know to do this. I don't know that a marker line can be drawn at a diagnol. You might try requesting an enhancement for something like this at http://www.birt-exchange.org/org/resources/bug-reporting/ and see what they say.

Chris605

Hi Michael,
first, thanks for your reply. I'm using Birt v. 2.3.2. I'm not sure, what you're meaning with recreating the issue with the sample database...

As I told, if f.e. I'm increasing the stepsize to 2 the entries are not laying one over the other. If I set the button "is category axis", everything with the x-Axis label is fine. But if I set this button the "standard" line is not more a line... But this could be a problem with the database entries. And I need to unselect "is category axis" because the range of the axis is scripted.

For the computed column (question 2), how is it possible to add an additional line to a row? I'm retrieving in "row['tscreate']" the timestamps from creating the database entries, e.g.

2010-06-01
2010-06-02
2010-06-03...

Now I want to add the timestamp from project start/finish for the standardline. The date is available as a global persistent variable, but I don't know how to add this to row["tscreate"], or how to add the row["tscreate"] and the variable to a computed column.

The result should look like this:

date of projectstart
2010-06-01
2010-06-02
2010-06-03
date of projectfinish

Thanks for any help,
Chris