What if scenarios

[#1]

I want to implement what if scenarios in my dashboard.

Right now I have a date and i add 24 to that date to generate newdate and then use the new date to plot graphs and charts.

I want a slider where i can add date + 24 or whatevr user enters: example +3, +5 or -5 etc and then a new date is generated

Below is current script:

Directory;

LOAD Foundry,

     [Part ID],

     Product,

     [Lot ID],

     Wfrs,

     [Layers Rem],

     [Fab Pos],

     [Fab Out Dt],

     F9

FROM

[FRODO.xlsx]

(ooxml, embedded labels, table is COMBINED);

COMBINED_FGOUTDT:

LOAD *,

date([Fab Out Dt]+ 24) as [FG Out Dt]

Resident COMBINED;

DROP Table COMBINED;

any direction on how to do this?

[hectorgarcia]

why dont you use variables in the GUI , that way users can modifu and simulate the results with their own values