Comments
-
Hi @GrantSmith !...Thank you so much for your response!..Yes I haven't used it before...Yes its useful..
-
Hi @Godiepi ...Really appreciate you getting back!..Can you please let me know what is the error with below code: CASE WHEN LEFT(`ORDERSTATUS`,1)='*' OR WHEN `ORDERSTATUS` like '%BAM%' THEN DATE_FORMAT(RIGHT(TRIM(`ORDERSTATUS`),10),'%m/%d/%Y') ELSE DATE_FORMAT(`orddate`,'%m/%d/%Y') end
-
Thanks @MarkSnodgrass !...Really appreciate your help!
-
Hi @MarkSnodgrass , Thank you so much for your response!..I also want to check if the first character is a * then I want to flag it 1.. For ex: *SLD 05/11/2022 - I need to flag this 1 ..*SOLD 05/15/2022 -I need to flag this 1 ,1277489 STK#39298.32831 * -I need to flag this 0..can you please let me know how to do this..
-
@GrantSmith : I tried this and it worked .. case when IFNULL(`QTYOPEN`,0)>(IFNULL(`QTY_ON_HAND`,0) + IFNULL(`QTY_OPN`,0)) then 1 else 0 end
-
Hi Grantsmith...Thanks for your response... Its giving me only 0 value and no any 1 but there are cases where open qty is greater than the sum of the other two
-
Thank you so much @MarkSnodgrass ...Really appreciate your help!
-
Hi @MarkSnodgrass ..This really works!...Also can you please let me know if the values in the quick filter can be sorted in descending order..I am not able to do the same..It is currently displaying as Week 01 2019 Week 01 2020 Week 01 2021
-
Hi @MarkSnodgrass : Appreciate your response!...I also want to display it as a quick filter as I have data from 2019 ...Thats where I am facing the problem
-
Thanks @MarkSnodgrass !..Appreciate your help!
-
@mhouston : Sorry for not being clear..I got the answer to this here
-
Hi @GrantSmith : Sorry this was a mistake at my end..Happy Friday! and Happy weekend
-
Thank you so much @GrantSmith !..Really appreciate your help!
-
Hi @GrantSmith : Thank you so much for your response! I am stuck at this step : This code will work for Magic 1 or Magic 2. Just cope the code in the code block below and then use Command+V (Mac) or Control+V (Windows) to paste the code into your Magic ETL palette. You will need to define the input dataset and the output…
-
@sfiene ...Appreciate your response...But I am not able to see any change to my output...
-
Hi All, Can you please help me here..The expectation is the distinct count of the combination of sales no and part_no ..But I am not getting the distinct count...can you please help me here..
-
@mhouston :Thanks a lot for your response!
-
Thanks @GrantSmith !
-
I am getting an error when I try to do the following formula CASE WHEN `REASONORINSTRUCTIONCODE`='R' THEN CONCAT('name-',`USERWHOENTEREDTHISLINE`,'reason-',`REASONSORSHIPPINGINSTRUCTIONS`) ELSE '' END as reason Can you please help here..
-
Hi All, Any help on this would be appreciated!
-
Thank you so much @GrantSmith and @MarkSnodgrass !..Really appreciate your help!
-
Hi @MarkSnodgrass , Following are the options available in my general option font Size Default Inner Margin Balanced Distribution Disable Animation Override Maximum Value Reverse Color Direction No Data Message
-
Hi @MarkSnodgrass : Appreciate your response!.. When I try to select the heatmap table the entire dataset changes to a heatmap....I am not able to see the chart properties at all.....
-
Hi @GrantSmith , I have an error in this formula below: CONCAT('<span style="color: ', CASE WHEN SUM(`BAM ALOC`)/sum(`LY SALES`) <> 0 THEN 'red' ELSE 'green' END, SUM(`BAM ALOC`)/sum(`LY SALES`)), '</span>’) Can you please help me here..
-
Hi @ST_-Superman-_ : When I try to use the Heatmap table card the entire table changes to heatmap..Can you please let me know how to use it for the two specific columns and then display the values along with the color..
-
Thanks @GrantSmith !..
-
@GrantSmith :Yes I have accepted the answer!
-
Thank you so much @GrantSmith and @MarkSnodgrass
-
To summarize The SKU from the mfg table and date should be taken and if the same SKU is present in the immediate previous date in the delay table then its status would be complete -1 and offdelay -1 The SKU from the mfg table and date should be taken and if the same SKU is not present in the immediate previous date in the…
-
Thank you @MarkSnodgrass !..Really appreciate your help!