I have a main table with 5 dates for Retail dashboard. How I can handle dates?
one way is to concatenate and create flag for each date but this is causing 'Out of memory error'
as app size going past 5 GB.
Main Table >> 15 million records
Main:
Load *,
Date1,
Date2,
Date3,
Date4,
Date5
;
Select * from Main;
Calendar:
Load
Date as Date1,
Month,
Year
;
UI requirement: I have 5 sheets, each sheet charts need to be restricted based on different dates.
eg: Sheet 1 Charts (Date1), Sheet 2 Charts (Date2)...