How to Fix Dynamic Year filter for displaying first 3 years in Bar chart

[gurusai sankar]

Hi All,

I have the data like Year , Cap cost & Exp cost

My requirement is

If user will select a aprticular yaer in the filter - It should display first 3 years dynamically (start year , startyear +1, start yaer +2 ) in the side by side barchart (X Axis: Year, Y axis: cap cost & Exp cost in Side by side bar )

Ex: If user selects 2018 - It should display 2018, 2019, 2020 dyanmically

Please suggest a right approach or any condition to fix this .

( Note : As per the data -My year coulmn is in String format and unable to chane into date as i am getting empty values)

Kindly help on this

 

Regards,

Guru

[Suraj Ullas 2]

Can you give more details as what type of filter you are using and some screenshots.

[Suraj Ullas 2]

I think the final answer will be a mix of Rscript + Doc Propoerty for this use case.

[Shuting Fu]

You can add a drop-down list document property, and set the property value using unique values in the YEAR column. Then go to the bar chart properties > Data > Limit data using expression, for example:

[YEAR] = ${StartYear} OR [YEAR] = Integer(${StartYear}) + 1 OR [YEAR] = Integer(${StartYeaer}) + 2