Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sorry, UNCHECK "suppress zero values"
Hi Tanel,
worked!!!! Quite simple if you know how to do it.
Thanks
Hey Markus,
I m sorry i dint get your question that you want to see months on Jan - Feb -March ...... format.
As Tanel has suggested its very good to have calender at script level , having Year , month , Quarter , Week , Day ..... for making work easier.....
but there is one more option if you are having Yearmonth filed , you can chage it at froent end also.
Month(YearMonth) -------- > in your dimesion.