X-axis grouping in the line chart

Hi,
I would like to have a line chart with an overview of time periods grouped by months. I have a dataset with columns (startdate(DATETIME), enddate(DATETIME), time period desc(DATETIME), value(FLOAT), indx name (string)).
Taking the time period desc in x-axis (as month data) and the value in y-axis and optional grouping as indx name. The x-axis should get grouped in order to display all the data points between each Time period.
 
for example, 
If the user selects a 05/31/16 startdate and to plot 5 Years TP, the axis should like (please check the attachment plot1)
 
the x-axis label would be,
05/16 05/15 05/14 05/13 05/12 05/11
 
In-between 05/16 to 05/15 we have 12 data points..so we need to show the 12 data points without x-axis TP (04/16, 03/16,02/16,01/16,12/15,11/15,10/15,09/15,08/15,07/15,06/15).
 
Please see the attachment Plot2 for reference. Can anyone please help me out in grouping the x-axis label as per the expectations.

Find more posts tagged with

Comments

pricher

Hi,
 
Based on your screenshots, I assume you're doing this with Open Source BIRT. If so, there are two ways you can do this:
 
1. without scripting
 
In Select Data, click on Edit Group and Sorting and select Months as the Grouping Unit;

JayanthiS

Hi Pricher,
Thanks for your quick response, The solution works fine for me. I have a question like how do I set the label interval dynamically using a script and at the same time need to hide the ticks for the label interval set. Could you please help me out on this?

pricher

Hi,
 
What do you mean exactly by "set the label interval dynamically"? Do you mean change the grouping dynamically (e.g. by year or month or quarter)? Or do you mean if grouped by month, show labels only for year (the example I sent you already), or every 3 months, or every 6 months?
 
As for hiding ticks, I believe it's all or nothing. I couldn't find an API call to hide ticks selectively.
 
P.

JayanthiS

Hi Pricher,
 
Sorry for replying late.
 
The logic for hiding the x-axis label works fine (I mean if I grouped by month, show the x-axis labels only for year/every 3 months/every 6 months), but at the same time I would like to hide the ticks for the same..Is there any work around available. It would be great if you could share some idea on this.
 
Thanks.

pricher

Hi,
 
As I said in my previous post, I could not find an API call to hide the ticks selectively.
 
P.

vijayshankar245

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="144304" data-time="1466081577">
<div>
Hi,
 
What do you mean exactly by "set the label interval dynamically"? Do you mean change the grouping dynamically (e.g. by year or month or quarter)? Or do you mean if grouped by month, show labels only for year (the example I sent you already), or every 3 months, or every 6 months?
 
As for hiding ticks, I believe it's all or nothing. I couldn't find an API call to hide ticks selectively.
 
P.
</div>
</blockquote>
Hi Pricher
Could you able to help me in dynamically change the x axis grouping by last 4 months wherever the report gets generated. I'm using bar chart in my report. BIRT version is 4.4.0.
I want to display x-axis lables as below,
Mar16 Apr16 May16 Jun16..

pricher

Hi,
 
If you want to get the data for the last four months, you should filter your query to return data only for the last four months. This has nothing to do with grouping.
 
P.

rajkishore

Try this for dynamic x-axis grouping.
<pre class="_prettyXprint">
importPackage( Packages. org.eclipse.birt.chart.model);importPackage (Packages.org.eclipse.birt.chart.model.attribute );cht = reportContext.getDesignHandle().findElement("mychart");mychart = cht.getReportItem().getProperty( "chart.instance" );xAxis =mychart.getAxes().get(0);xSeriesDef = xAxis.getSeriesDefinitions().get(0);xGrouping = xSeriesDef.getGrouping();xGrouping.setGroupingUnit(GroupingUnitType.MONTHS_LITERAL); // You can also use WEEKS_LITERAL, DAYS_LITERAL, YEARS_LITERAL</pre>

shamo

Do something like this on you dataset in the where clause. some thing like datefield between add_months( current_Date, -8) and add_months(current_Date,-4) or with same concept but filter on the chart with the date field between min value using datefunctions to add months.

vijayshankar245

<blockquote class="ipsBlockquote" data-author="shamo" data-cid="144599" data-time="1468500513">
<div>
Do something like this on you dataset in the where clause. some thing like datefield between add_months( current_Date, -8) and add_months(current_Date,-4) or with same concept but filter on the chart with the date field between min value using datefunctions to add months.
</div>
</blockquote>
Thanks.
 
Have added filter to get data only for the last 4 months. It worked.

vijayshankar245

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="144590" data-time="1468414481">
<div>
Hi,
 
If you want to get the data for the last four months, you should filter your query to return data only for the last four months. This has nothing to do with grouping.
 
P.
</div>
</blockquote>
I have a bar chart with an overview of time periods grouped by weeks. my requirement is show data for the last 6 weeks. have added a filter in the chart to show only last 6 weeks. The chart groups data from sunday to saturday of a particular week and shows as sunday's date. please check the attached image, i have filtered the date from 20-06-2016 to 31-07-2016. 
I need the chart to show values like 26th june,03rd july,10th july, 17th july,24th july, 31st july.
But the graph starts value from 19th june. ideally it should start from 26th june, since i have given start date as 20th june, it should calculate the values from 20- 25th june and show the sum in 26th june 2016 and so on. Please help how do i change the calculation here.

pricher

Hi,
 
If you want the total for the week to show on the following Sunday in your chart, simply add a computed column in your data set that adds one week to the original date, and use that date as the X-Axis grouping. So, if the original date in your data set is MyDate, add a new computed column named MyDatePlusOneWeek using the following expression:
<pre class="_prettyXprint _lang-">
BirtDateTime.addWeek(row["MyDate"],1)
</pre>
The filter to get the last 6 weeks of data should still happen on the original date.
 
I am attaching an example using a CSV file.
 
Hope this helps,
 
P.

vijayshankar245

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="144798" data-time="1470232633">
<div>
Hi,
 
If you want the total for the week to show on the following Sunday in your chart, simply add a computed column in your data set that adds one week to the original date, and use that date as the X-Axis grouping. So, if the original date in your data set is MyDate, add a new computed column named MyDatePlusOneWeek using the following expression:
<pre class="_prettyXprint _lang-">
BirtDateTime.addWeek(row["MyDate"],1)
</pre>
The filter to get the last 6 weeks of data should still happen on the original date.
 
I am attaching an example using a CSV file.
 
Hope this helps,
 
P.
</div>
</blockquote>
Thanks a lot Pierre.
The above solution works. but shows last 7 weeks even after giving filter to show only 6 weeks data. I need the chart to show upto 31st july but the chart is showing till 07th august. since we are giving filter upto 31st july, the data on 31st july is reflecting on 7th august. If you see the screenshot of your example, value 1 is showing on 7th august.
 
I have tried reducing the filter to 30th july. but the chart shows only 5 weeks till 24th july. Is there any other way to hide the last value or remove the last entry in the chart?

pricher

Hi,
 
Change the expression in the MyDataPlusOneWeek computed column to add 6 days instead of a week:
<pre class="_prettyXprint _lang-">
BirtDateTime.addDay(row["MyDate"],6)
</pre>
P.

vijayshankar245

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="144813" data-time="1470321894">
<div>
Hi,
 
Change the expression in the MyDataPlusOneWeek computed column to add 6 days instead of a week:
<pre class="_prettyXprint _lang-">
BirtDateTime.addDay(row["MyDate"],6)
</pre>
P.
</div>
</blockquote>
Thanks a lot Pierre.