Comments
-
Thanks @MarkSnodgrass !..This works..Appreciate your help!
-
I tried the beast mode like this :CONCAT(YEAR(`REQ_PIC_DATE`),'-',MONTHNAME(`REQ_PIC_DATE`)) order by YEAR(`REQ_PIC_DATE`),MONTHNAME(`REQ_PIC_DATE`)...But its invalid...
-
@mhouston : The values in my quick filter still don't appear in the ascending order...Only the values in my data table are sorted in ascending when I drag my beast mode to sorting and select ascending...
-
@mhouston ...Appreciate your response!..Can you please guide me on the sort beast mode on CONCAT(YEAR(`pickupDATE`),'-',MONTH(`pickupDATE`)).
-
Hi everyone..Any help on this will be much appreciated!
-
Sure @MarkSnodgrass ..Appreciate your suggestion!
-
@MarkSnodgrass : The column names should change every fiscal month according to the reference table dynamically ..For example FC1 should be renamed to May 2022 and FC2 should be renamed to June 2022 from 24th April 2022...Similarly from 22nd may 2022 FC1 should be renamed to June 2022, FC2 should be renamed to July 2022...
-
Hi All, I was able to get this done myself!...I used a lead function with date operations and was able to get this done
-
Thank you so much @GrantSmith !..Really appreciate your help!
-
Hi @MarkSnodgrass and @jaeW_at_Onyx : Really appreciate you getting back!..Any guidance on setting up the Magic ETL would be really helpful for me...