How to display /sort year in a line graph

[#1]

Hi,

I have a data set that has financial information from 1980 to 2018 I only want to create a line graph showing the information from 2010 - 2018. how do i achieve this please assist.

Thank you

Regards

Saran

[MK_QSL]

Use below as dimension

IF(Year >= 2010,Year)

Tick Suppress When Value is Null

[rospigliosi]

... and sort as Numeric value

[#4]

it is still displaying all years

[#5]

I have tried  this but there is an issue with the function

[isorinrusu]

Make sure you use the equal sign in the dimension and that your year dimension is called 'Year':

=IF(Year >= 2010,Year)

Upload a screenshot of your dimension if it does not work.

Regards,

Sorin.

[#7]

[#8]

=IF(deposit_date >= 2015,deposit_date)

I used this but it is still displaying data from 1973 ..

i need to show data from 2010 only

[isorinrusu]

Saran, you need to convert the deposit_date to Year format. Your dimension then will be:

=IF(Year(deposit_date) >= 2015,deposit_date)

[#10]

deposit_date	currency_id	amount_usd
10/12/2011	167	397142
10/12/1999	167	401276
10/12/1975	167	325019
10/12/2015	167	108586
10/12/2015	167	34519
10/12/2015	167	559
10/12/2015	167	70049.03
09/12/2015	167	212031.56
08/12/2016	167	209878.95
07/12/2011	29	454545.45

    This is a sample of the data i have