SAC Story Time dimension issue (Previous year data display issue )

[yoursraghu986]

Hi All,

 Need your Input on Time  Dimension 

Our requirement is  we have data since 1995 to 2025

Using Input control or Filer when select 202503 as single selection  as date we need to see date from 1995 to 202503

Can you suggest in detail 

[William_Yu]

1. Define a page filter(input control) or a story filter with range on time dimension 
2. Create a current date input control with month granularity
3. Define a range with lookback with 30 years

User select the month from current date input control, report shows all the period back 30 years. 

[yoursraghu986]

@William_Yu is there alternate way with script based on current input date to bring previous data .......script on (Filter /control---------Drop Down , range slider..ete) or best way you request

[William_Yu]

I'm not sure what exactly you are looking for, with my recommended option, user is still able to toggle how many years to look back. If you really want scripting, I believe you should be able to get current selected date and manipulate the date filter directly.

[yoursraghu986]

@William_Yu is it possible to allow the user to Dynamically change the current date input control ? instead of changing how many year to look back ..our current requirement is look back 1200 months is fixed. The user wants to dynamically change current date .

[William_Yu]

Yes, you even use script to set a default value for the current date input control on story loading, and then user is still able to change it.

[yoursraghu986]

@William_Yu Can you help with Steps or scripts its would be great