Jump to content
We've recently updated our Privacy Statement, available here. ×

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


Sony Hejmady

Recommended Posts

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")

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...