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?
