Chart - dimension show only last X months

[Anonymous]

Hi QV friends,

i have a chart with a "Year-Month" dimension,

i want to show only last x months,

how can i show only them on the chart?

definition example:

Year-month = 2014-Dec

[mdmukramali]

Dear ,

You can use Dimension Limit option to display only Last x Months.

else

Can you attach the sample file.

so that we can help you in better way.

Thanks,

Mukram

[its_anandrjs]

Hi,

You can use SET analysis for this provide any sample data for working.

Regards

Anand

[Anonymous]

how?

I only have largest,

while my dimension is Year-month, (to my understanding should be sorted by load descending - becuase it's text)

[Anonymous]

my dimension is text based (year-month),

how can i set analysis it?

[ecolomer]

See this example for 12 months

[ecolomer · Accepted solution]

you need to convert to date format as 'YYYY-MMM' or 'YYYY-MM'

[its_anandrjs]

Hi,

If you want to display last and latest month data then add

Dimension as MonthYear field

I assume [Test Month Name] is text field here

Expre:-

sum({<[Text Month Name] = {'$(=Text(Max( Date(Date#([Text Month Name],'MMM YYYY'),'MMM YYYY'))))'}>}  Metrics)

By this you get last months amount

Regards

Anand