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; } } }

Bar Chart - Minimum value on Axis?

Chrisrustydog

I have a bar chart with an X axis showing yearly intervals. In the attached image, you can see how I set the minimum starting value to a specific year. 
 
Is there a way to make the minimum value the current year? I was thinking that there would be a way to set the minimum starting value to some kind of logical statement such as sql syntax - YEAR(GetDate())

Find more posts tagged with

Comments

Clement Wong

I'm assuming that you're using OS BIRT based on your other posts. Also, I'm assuming that your X-Axis "Is Category Axis" setting is not checked.
 
If so, then, you can use the following in your Chart's onRender > beforeGeneration event:
<pre class="_prettyXprint">
function beforeGeneration( chart, icsc )
{
importPackage( Packages.org.eclipse.birt.chart.model.data.impl );
importPackage( Packages.org.eclipse.birt.chart.util );

xAxis = chart.getBaseAxes()[0];
scale = xAxis.getScale();
scale.setMin( DateTimeDataElementImpl.create( new CDateTime(BirtDateTime.year(BirtDateTime.now()),1,1) ) );
//scale.setMax( DateTimeDataElementImpl.create( new CDateTime(BirtDateTime.year(BirtDateTime.now()),1,1) ) );
}</pre>

Chrisrustydog

Thanks for your response.
 
I am not sure what OS BIRT is. I am using the free edition.
 
My programming knowledge is limited to some XML and very little javascript, below average at best. I am decent with writing SQL queries though - Curious, does one need to be well versed in Java Script in order to utilize the scripting capabilities in BIRT? Would you say that knowing how to script in BIRT is essential to unlocking the applications primary functionality or is it just "nice to have" ?
 
I did some googling to understand how and where to implement the script you gave me and I think I've done it right (see image #1). I am running the report, but the axis is not updating. Er, as I am typing this, I realized that I am using a flipped axis orientation (see image #2), so I misspoke about the X axis. I am really trying to do this to the Y axis, yes?

Clement Wong

OS BIRT = Open Source BIRT = "Free" Edition
 
For basic tasks, you shouldn't need to dive into the scripts. However, it's really nice to have since you'll be able to customize BIRT to your specific business requirements.
 
You did find the right spot for the script. What I assumed is that you were using a line chart, and not bar.
 
Actually, the easiest thing to do, now that I think about your requirements again, without scripting is... Add a filter to your chart!
 
Select the Chart.
Under Property Editor - Chart (in the lower right pane), select the Filters tab.
Enter a filter condition.
 
Here you can either build a expression like the following:
 
BirtDateTime.year(row["YourDataSetColumn"]) Greater than or Equal BirtDateTime.year(BirtDateTime.today())
 
 
Attached is an example created in OS BIRT 4.5.0.

RakhiR

Hello,
 
Can you please help me to set start value of X-axis as min value of date column.
 
 I have set Origin as Min inside Y-Aixs properties. Now the min date is Oct 2012 , But the graph starts one step previous to this.
 
No category Axis.

Clement Wong

Please provide whether you are using commercial, or open source BIRT? What version of BIRT you are using?
 
Also, if you have an example design using Classic Models of what you already tried and replicates what you are currently seeing?
 
(Please start a new thread in the future.)