Display Axes even if there is no data

[#1]

Hi All

I need a little help. I have some transaction data which has a date component:

Jan 2013 - 20 units

Feb 2013 - 50 units

Mar 2013 - 60 units

Apr 2013 - 15 units

and so on

When i have this in a chart it all works fine, but i have a situation where I would like to display the whole year on the x-axis even though there is no data yet for May to Dec 2013. Is there a way to get the x-axis to show all the months regardless of having data or not?

Thanks

JP

[shree909]

Hi try to create an inline table

[Calendar]:

LOAD * INLINE [

    Month_ID, Month Year, Quarter

    1, Jan 2013,Q1

    2, Feb 2013, Q1

    3, Mar 2013, Q1

    4, Ap 2013, Q2

    5, May 2013, Q2

    6, Jun 2013, Q2

    7, Jul 2013, Q3

    8, Aug 2013, Q3

    9, Sep 2013, Q3

    10, Oct2013, Q4

    11, Nov 2013, Q4

    12, Dec2013, Q4

];

then load ur table

join (Calendar)

load  * from

    ...

then use the monthyear as the dimension  on the x-axis.

Thanks

[#3]

Thanks for the response. I already have a table like this which i use for the x-axis, but it only shows the months that have data, I need all the months to show.

Regards

JP

[er_mohit · Accepted solution]

I think if you are using Chart then go to presentation tab and uncheck Suppress Zero values and Check on Zero on bars

or if you are using pivot or straight table then only uncheck the suppress zero value

hope it helps

[#5]

Brilliant thanks a mil.

Cheers

JP