Eclipse Community Forums: BIRT » Year-to-date function with missing values

Home

Home » Archived » BIRT » Year-to-date function with missing values

Year-to-date function with missing values [message #1073175]

Wed, 24 July 2013 05:11

Eclipse User

Hi,

We use a "relative time periods" Year-To-date function with Eclipse designer 4.3:

index.php/fa/15680/0/

This feature is awesome but we face to a problem when a month return no data in a cell. In the crosstable picture attached making use of the sample database, property "For empty cells, show" is set to "0". We can see there is no data for "Motorcycle" in march, though year-to-date should return the same value as february (953), not 0. This is not the expected behavior in charts, and it makes Total by month inconsistent with the sum of rows: in march, the total is 8694 which is the expected value. But the sum of rows is 7741, because the motorcycle value 953 is missing.

index.php/fa/15681/0/

It seems to be the same with all other functions such "Trailing N month" or "Current Year"

Please could you help? Is there any tip to force relative time periods calculations even for empty months?

Thanks!

Attachment: YearToDate.png
(Size: 44.82KB, Downloaded 952 times)
Attachment: year-to-date.png
(Size: 29.39KB, Downloaded 839 times)

[Updated on: Wed, 24 July 2013 05:15] by Moderator

Re: Year-to-date function with missing values [message #1075317 is a reply to message #1073175]

Mon, 29 July 2013 04:18

Eclipse User

I tried every datacube/crosstab option, nothing helped. I also tried to use a derived measure to return 0 when missing, but relative time periods don't work on a derived measure.

I found a workaround through scripts, by injectings rows with a 0 value for the first day of each month, for each product line. That's quite tricky, i believed it is the kind of thing "relative time periods" was supposed avoid doing. But it works...

index.php/fa/15743/0/

Attachment: YTD-injected-missing-values.png
(Size: 27.98KB, Downloaded 775 times)

[Updated on: Mon, 29 July 2013 04:26] by Moderator

Re: Year-to-date function with missing values [message #1075668 is a reply to message #1075317]

Mon, 29 July 2013 16:56

Eclipse User

Glad you found a solution. You might log a bug for this.

Previous Topic:	How to ?
Next Topic:	Show Header only on first page BIRT

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Mar 22 09:07:31 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter