Eclipse Community Forums: BIRT » MEDIAN function on string???

Home

Home » Archived » BIRT » MEDIAN function on string???(Is it possible to have median function on string?)

MEDIAN function on string??? [message #735945]

Thu, 13 October 2011 03:28

Eclipse User

I have this column which represents difference between some actual and target start.Using DB2 functions timestampdiff,Floor and Mod I have this difference in format days--hours--minutes.
Now my customer wants median value of that column.
By using embedded MEDIAN function in BIRT I receive as result only "0".
In this case result should be 0 days 0 hours 1 minutes.
Is it possible to have median result in this format?

Thanks

Attachment: actual response.jpg
(Size: 45.98KB, Downloaded 1130 times)

Re: MEDIAN function on string??? [message #736113 is a reply to message #735945]

Thu, 13 October 2011 11:44

Eclipse User

You could always use birt date diff on the minute and then use another
computed column to convert it to a string. Have a look at the attached
example. Specifically look at the two computed columns on the dataset.

Jason

On 10/13/2011 3:28 AM, cankovicv wrote:
> I have this column which represents difference between some actual and target start.Using DB2 functions timestampdiff,Floor and Mod I have this difference in format days--hours--minutes.
> Now my customer wants median value of that column.
> By using embedded MEDIAN function in BIRT I receive as result only "0".
> In this case result should be 0 days 0 hours 1 minutes.
> Is it possible to have median result in this format?
>
> Thanks

Attachment: median.zip
(Size: 2.79KB, Downloaded 379 times)

Re: MEDIAN function on string??? [message #741202 is a reply to message #736113]

Wed, 19 October 2011 05:36

Eclipse User

Hi Jason. Thanks for your reply and effort. You are really helping me.
You send me great example and I did it all like you. My computed column Median Minutes is always correct calculated but medianstring computed column is always empty.
I don't know why? I tried with some simple example just as Float to calculate from Median Computed column divided by 24 but that is also empty. Do you see maybe what is wrong? Here is all settings:

index.php/fa/4418/0/

Attachment: median.jpg
(Size: 272.36KB, Downloaded 1232 times)

[Updated on: Wed, 19 October 2011 05:39] by Moderator

Re: MEDIAN function on string??? [message #741215 is a reply to message #736113]

Wed, 19 October 2011 05:51

Eclipse User

Hi Jason. Thanks for your reply and effort. You are really helping me.
You send me great example and I did it all like you. My Median Minutes column is always correct calculated but medianstring column is always empty. I copy paste your example but it stays empty. I tried and with simple example to use that column as Float-- Median Minutes divided with 24 but it stays empty. Do you maybe see what am I doing wrong? Here is all the settings:
index.php/fa/4419/0/

Attachment: median.jpg
(Size: 272.36KB, Downloaded 1054 times)

Re: MEDIAN function on string??? [message #741275 is a reply to message #735945]

Wed, 19 October 2011 07:10

Eclipse User

Jason just to add-- I added new computed column which calculates from standard output column INCIDENTID and that works ok. But for similar expression medianstring stays empty. It's like medianstring cant pull out information from computed Median Minutes column. do you know the reason?
thanks for help

index.php/fa/4420/0/

Attachment: median2.jpg
(Size: 157.81KB, Downloaded 1093 times)

Re: MEDIAN function on string??? [message #741449 is a reply to message #741275]

Wed, 19 October 2011 10:44

Eclipse User

What happens if you change the type of medianstring to String and then
use this expression:

var mytime = row["MedianMinutes"];
tst = "Testing " + mytime

Jason

On 10/19/2011 7:10 AM, cankovicv wrote:
> Jason just to add-- I added new computed column which calculates from standard output column INCIDENTID and that works ok. But for similar expression medianstring stays empty. It's like medianstring cant pull out information from computed Median Minutes column. do you know the reason?
> thanks for help
>
>
>

Re: MEDIAN function on string??? [message #742140 is a reply to message #741449]

Thu, 20 October 2011 04:05

Eclipse User

Hi Jason.

It's again empty.
But never mind I succeeded to present median string results. Solution was that I used only one computed column (Median Minutes) and on report medianstring column is not bound to medianstring computed column.I bound it with expression

var mytime = row["MedianMinutes"];
var mytime3=BirtMath.roundDown(BirtMath.divide(BirtMath.mod(mytime,1440),60),0);
var mytime2=BirtMath.roundDown(BirtMath.divide(mytime,1440),0);
mytime2 + "days " + mytime3 + " hours " + mytime%60 + " minutes";

Now it works OK. I just have only one question can I display this result just in one field-out of the table in some field. Because this result can be repeted n-times through the table as you can see in attachment. I saw also that in your example also there was repetition of result?? Can it be shown only once??

Thanks,best regards

index.php/fa/4435/0/

Attachment: median3.jpg
(Size: 211.42KB, Downloaded 1065 times)

Re: MEDIAN function on string??? [message #742494 is a reply to message #742140]

Thu, 20 October 2011 10:44

Eclipse User

Select the column on the table and look in the general properties.
There is a check box to suppress duplicates.

Jason

On 10/20/2011 4:05 AM, cankovicv wrote:
> Hi Jason.
>
> It's again empty.
> But never mind I succeeded to present median string results. Solution was that I used only one computed column (Median Minutes) and on report medianstring column is not bound to medianstring computed column.I bound it with expression
>
> var mytime = row["MedianMinutes"];
> var mytime3=BirtMath.roundDown(BirtMath.divide(BirtMath.mod(mytime,1440),60),0);
> var mytime2=BirtMath.roundDown(BirtMath.divide(mytime,1440),0);
> mytime2 + "days " + mytime3 + " hours " + mytime%60 + " minutes";
>
>
> Now it works OK. I just have only one question can I display this result just in one field-out of the table in some field. Because this result can be repeted n-times through the table as you can see in attachment. I saw also that in your example also there was repetition of result?? Can it be shown only once??
>
> Thanks,best regards
>
>
>

Re: MEDIAN function on string??? [message #743209 is a reply to message #742494]

Fri, 21 October 2011 04:17

Eclipse User

Thanks man. You are genius:)

I thought that maybe there is a way to present it out of table but this is OK also.

Cheers, wish you all the best!

Previous Topic:	How to set chart series name in javascript
Next Topic:	Custom emitter

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 26 08:03:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter