Full timeline of one year in bar chart

[#1]

Hi,

i am trying to create a full timeline for one year (Jan-Dec) in a bar chart having only 2 month with values for the current year.

The chart should be displayed in a report always displaying a full year. I tried to create a calender with the format YYYYMM filling up the missing values. I presume that the missing month are not displayed because the data table is having only 2 month filled with values.

I already checked other posts but didn't find the right solution.

I attached the example.

Regards

Markus

[#2]

HI can you share you application

[#3]

Hi,

a example is attached above. I can't share the original.

[#4]

HI,

In your application , yo have used expression as

SUM ({$< YEAR = {"2011"} >} commissions)

Its hard coded to Year 2011. So it will show data only according to year - 2011.

Chage It to

if( Year = $(=Max(Year)) , Commissions)

I hope this will work.

[#5]

On Chart Properties > Presentation ... uncheck ... Suppress Zero-Values

[#6]

Hi,

sorry but that didn't work.

[#7]

Hi,

i tried that already but then the x-axis has all vlaues declared in the calender but displays only bars in 2011.

My intention is to have a chart displaying a full year on the x-axis (Jan-Dec 2011) having only bars for January and February (values are only available for these 2 month)

[#8]

In your apllication data is only availabe for 2 months which is displaying on front end.

when it will have data for all the months , it will display Jan-Dec.

Here in aplication you can select on differnet years to do analysis

[#9]

Ashwin,

thanks for the example. But it is not exactly what i am trying to do. What i mentioned before is to have the full year being displayed on the x-axis (Jan-Dec) in the bar chart. In the chart there should be only bars for January and February and March to December i presume would have Null values and the month < 2011 should be also suppressed.

[tanelry]

In the script add pure month dimension to your calendar table,
I mean using month(...) as month.

Then use this month as your chart dimension and check "suppress zero values".