last 6 month

[cscherer]

Hello,

I want to create a chart, where I only see the data for the last 6 month. How can I create a new field with the last 6 month? I got two variables for the current month and for month-6, but I don`t know how to go on...

Thanks for your help in advance,
Clemens

[sreenivas]

Check this file

[cscherer]

ok, but how did you make it?

[sreenivas]

In dimension Limits Restrict the Number of Bars to be displayed and sort it in the yearmonth order

[cscherer]

I see. But is it possible to have the current month on the right side of the chart?

[sreenivas · Accepted solution]

Fimd the updated

[cscherer]

thanks!

[#8]

This doesn't quite work.

The data presented is displaying the largest 6 months.

Jan, Mar, Apr, May, Jun, Jul

As a result January is being displayed instead of February.

There is an option for first, but no one for last.

Any other solutions?