document property

[venkataramana kondra]

Hello Everyone

can any one help with the following i have two columns like max_effective_date and firt_stmt_dt my requirement is i need put one drop_down with values 'Last 30 Days','Last 60 Days','Last 90 Days','Last 180 Days' and 'Last 12 Months' then once the user select last 30 days on X axis the date should be show last 30 date from 'Max_Effective_Date' and similor for next four values in drop-down

i created drop-down (DateRangeSelection)with expression

case WHEN '${DateRangeSelection}'='Last 60 Days' THEN DateAdd('dd',-60,[Max Effective Date]) END

throwing Error'${DateRangeSelection}' has circular definition Error

can any one give step by step solutions for that and in limit data by expresion which one i need to select

 

 

Thanks