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

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

gurusai sankar

Recommended Posts

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




Link to comment
Share on other sites

  • 4 months later...

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

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...