Skip to Content

Rolling 12 Months data Even though Months do not exists should show Month.

Dec 02, 2016 at 10:13 PM


avatar image

capture.pngHello Guru's,

This question must have been asked multiple times but in accordance of Calmonth/Calday/Year. However in my requirement I need to show rolling 12 months data current month -3, Current Month and current Month+8 months based on Valid To Month . This works fine with offset variable but what if the data for that Valid To Month does not exisits? Offset variable restricts within that range but does not show month for which data does not exists. My report is based on Valid To Date so there are chances that some months data won't exist because none are expiring in that month. I tired using RKF's and creating structure still it does not work because the particular months data might not exists and my Bar graph on front end(Webi) breaks because instead of 12 bars now it shows only 11 bars. Please let me know How can we show 12 months rolling even though data for some month might not exist?

Attached is snapshot for bar chart showing only 10 months, Any help appreciated.



capture.png (18.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Cornelia Lezoch Dec 07, 2016 at 12:41 PM

Hi Sam,

go to your query designer and to the properties of the month characteristic that you use.

go to the extended settings and choose to show values according to "master data".



10 |10000 characters needed characters left characters exceeded
Sam Govaski Jan 18, 2017 at 06:57 PM

Issue resolved I used +0 in the formula that way even though if data does not exisits for that month will show null+0 =0 as place holder for that month.

10 |10000 characters needed characters left characters exceeded