Data limiting: how to get last 6 month data in Line graph.

[Sony Hejmady]

I have a requirement where I have a column Period of type "String" which has Year and Months data as seen below.For example the below value 1708=2017 year and 08= August Month.

Period (String type)

---------

1708

1709

1801

1802

1803

1804

1810

1811

1812

1901

I need to see last 6 months record in line chart.

I tried with following expression which works but every time when records keeps piling I need to manually update the Month data.Please help.

String("1807")

[Gaia Paolini]

Hi

Try this:compare the current year and month with the year and month in the period:

Logical formula:

12*(YearNow-YearPeriod) + (MonthNow-MonthPeriod)

This worked for me,either as a calculated column, or an expression to limit the line chart by:

(12 * (Integer(TERR_String("output

[Sony Hejmady]

Thank You Gaia :)