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

How to beggin

fporcher · 2009-02-11T05:50:13+00:00

Hi, My resultset get data since 2 Years First Row an distinct Id (string), Second a float Value, Thrid A date …

fporcher

Hi, 
My resultset get data since 2 Years 
First Row an distinct Id (string), Second a float Value, Thrid A date 
<pre class='_prettyXprint _lang-auto _linenums:0'>
ID-1004 6.666666805744171 2008-02-18 00:00:00
ID-1005 9.594998836517334 2008-02-18 00:00:00
ID-1007 32.400001525878906 2008-02-18 00:00:00
ID-1008 44.91666316986084 2008-02-14 00:00:00
...
</pre>
I want "draw" a chart : 
Y serie : 1 year group by month 
X serie 1 : bar - the means of float value meanning to the month and number of Id 
X serie 2 : area - the moving average based on 12 previous month 
X serie 3 : External Value (Goal to reach) 
 
A prototype is joined ... 
 
So, how to start 
 
F.P.

Find more posts tagged with

Comments

mwilliams

Hi F.P.,

You can do multiple series types on a single chart. See the following screenshot. Let me know if you have any other questions.

fporcher

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi F.P., 
 
You can do multiple series types on a single chart. See the following screenshot. Let me know if you have any other questions.</blockquote>
 
Hi, 
Thanks, but my problem concern more how to manipulate/aggregate Data. 
I create a datacube 
* group by year/month/day 
* a summary fields 
** count(id) 
** sum(value) 
 
I create a bar chart (to start) 
In X series data["byDay/year"] + "/" + data["byDay/month"] 
In Y series how to make a expression like 
data["cube/sum_value"] / (data["cube/count_id"] * max day in month); 
I try an expression 
<blockquote class='ipsBlockquote' >
importPackage(Packages.java.text); 
importPackage(Packages.java.util.Calendar); 
sdf = new SimpleDateFormat("yyyy/MM"); 
current = data["byDay/year"] + "/" + data["byDay/month"]; 
datecurrent = sdf.parse(current); 
calendar = Calendar.getInstance(); 
calendar.set(Calendar.DATE, datecurrent); 
lastDay = calendar.get(Calendar.DAY_OF_WEEK); 
data["cube/sum_value"] / (data["cube/count_id"] * lastDay) </blockquote>
but Birt doesn't found an expression

fporcher

I reply to myself, 
I found a solution (maybe not THE solution) 
 
I create a datacube 
Groupe By Date (Year, Month, Day of the Year) 
Summray 
* count on ID 
* sum on value 
 
Next step, I create un Chart 
on X series 
<blockquote class='ipsBlockquote' >
new Date( data["byDay/year"], data["byDay/month"],0) </blockquote>
on Y serie 
<blockquote class='ipsBlockquote' >
if( ((new Date().getMonth()+1)==data["byDay/month"])&& ((new Date().getFullYear())==data["byDay/month"]) ){ 
data["cube/demerite_issue"]/data["cube/jira_issue"]/(new Date().getDate()); 
}else{ 
data["cube/demerite_issue"]/data["cube/jira_issue"]/(new Date( data["byDay/year"], data["byDay/month"],0).getDate()); 
} </blockquote>
 
So it works. If anyone has simplier ... 
Now the moving average on 1 year ...

fporcher

Why Birt don't recognise a DateTime in the expression new Date( data["byDay/year"], data["byDay/month"],0).getDate() ? (I change pattern for X series to DateTime)

mwilliams

F.P.,

I don't think you'd need the '.getDate()' on there, new Date() returns a date already. If the "data" values are numbers, this should give you a date. What are you getting? An error?

fporcher

<blockquote class='ipsBlockquote' data-author="mwilliams">F.P., 
 
I don't think you'd need the '.getDate()' on there, new Date() returns a date already. If the "data" values are numbers, this should give you a date. What are you getting? An error?</blockquote>
(BIRT' version 2.3.1) 
I used <blockquote class='ipsBlockquote' >new Date( data["byDay/year"], data["byDay/month"],0)</blockquote>
The windows edit charts don't render a preview, and I have an error (@see screenshot.1234791963.jpg ) <blockquote class='ipsBlockquote' >Unable to use a non-datetime data to render a datetime axis</blockquote>. 
On onglet Format Chart I use a datetime type, that is what Birt don't appreciate (@see screenshot.1234792112.jpg )... 
The report is generated (@see preview.jpg )....

mwilliams

F.P.,

Can you recreate this issue with the sample database and attach that report, so I can see it myself? Thanks.

fporcher

<blockquote class='ipsBlockquote' data-author="mwilliams">F.P., 
 
Can you recreate this issue with the sample database and attach that report, so I can see it myself? Thanks.</blockquote>
Yes , see attachment

mwilliams

F.P., 
 
I would say that that's probably a bug. You can log the bug at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a>. Be sure to include a good description and screen shots. Please post any bug info in here for future reference. 
 
As an easy workaround, you can add a binding to the chart in the binding tab of the property editor and use your expression there in a date or date time type binding. Then, in your chart editor, you can use the expression builder to choose that new binding for the x-axis value. That should do it.

fporcher

<blockquote class='ipsBlockquote' data-author="mwilliams">F.P., 
 
I would say that that's probably a bug. You can log the bug at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a>. Be sure to include a good description and screen shots. Please post any bug info in here for future reference. </blockquote>
It's done (<a class='bbc_url' href='https://bugs.eclipse.org/bugs/show_bug.cgi?id=265946'>Bug 265946</a>) 
<blockquote class='ipsBlockquote' data-author="mwilliams">
As an easy workaround, you can add a binding to the chart in the binding tab of the property editor and use your expression there in a date or date time type binding. Then, in your chart editor, you can use the expression builder to choose that new binding for the x-axis value. That should do it.</blockquote>
 
I've created a col computed in the dataset ... more easier to manage data.