Manupulate axis. Show month-year only

[#1]

Hi,

Need to show all data points (sum per date),

however I only wanna see month-Year on the dimension axis, for instance "Jan-2015".

As you can see, showing all dates does not work that well.

Any ideas?

[sunny_talwar]

What happens when you change your dimension from Date to MonthName(Date) and on the axis tab keep the axis continuous?

Best,

Sunny

[#3]

This happens, only one sum per month (also numbers instead of the actual month name).

//O

[sunny_talwar]

Can you share a sample

Best,

Sunny

[buzzy996]

try this way,

Need to show all data points (sum per date), ---activate scroll bar from prenstaction tab---Chart scrolling--Enable X-Axis scroll bar.

however I only wanna see month-Year on the dimension axis, for instance "Jan-2015". ---use calculated dimension as Month(Datefield))&'-'&Year(Datefield)

[ankitaag]

Write the calculated dimension as =Month(Date)&'-'&Year(Date)

[#7]

Pls see attached

//O

[Anonymous · Accepted solution]

The closest I can think of is to keep Date as dimension but to use continuous x-axes.  Still there is a problem - Months may be skipped or duplicated depends on the chart size.

[stigchel]

You can also disable the dimension Show Label and add an extra expression with Text on Axis enabled, something like

=if(Date=MonthStart(Date),Month(Date))&'-'&Year(Date))