Thank you for the help appreciate it will give this a shot

CASE WHEN SUM(CASE WHEN WAREHOUSE_CODE IN (18, 19) THEN 1 ELSE 0 END) FIXED(BY WAREHOUSE_CODE FILTER NONE) > 0 THEN 'Exists' ELSE 'Does Not Exist' END When I am using this calculation in beast mode I am receiving this error "An issue has occurred during processing. We are unable to complete the request at this time -…

Sure provided are the screenshots This is an example of the SKU that is giving me issues Here are the mail dates associated with the SKU at hand 46476 my formula which is CASE WHEN MailDate > CURRENT_DATE() THEN 'Future Mail Date' ELSE 'Past or Present Mail Date' END is intended to filter out any SKU that has any…

@GrantSmith I am trying to save the PCT Ad Cost Dollars to the dataset from the card it works with and that it can be saved with but I am receiving this error.

@MarkSnodgrass I had a follow-up question on this same question is there any way to achieve this same solution via beast mode? I am having a tough time using the magic etl tool.

Thank you so much for the quick response @ColemenWilson and @GrantSmith appreciate it!✊

Hi @jessdoe Sorry I think the issue is with prod sourcing I included the column in this screen shot but the formula is giving me the first 3 characters when i only need the third character of the string. Here is the screen shot: The formula that is giving me the first 3 letters which is only supposed to give only the third…

Hey @jessdoe @GrantSmith thank you so much for the previous formula so I am running into an issue with it. So it seems like the first condition is coming correctly if Prod Art = A then I am getting artwork but when the second condition comes into effect it doesn't give me sourcing when the 3rd character in product number =…

Hi Grant, Thank you for the quick response seems like there is a syntax error with the code do you know what it could be?

@jessdoe

Had one more question regarding this topic I am not sure if there is a OR operator in domo beast mode but I am trying to make a formula where if "prod art" is "A" then display "Artwork" else if when "Prod Source" is "M" then "Sourcing" Else "No" Here is the formula i have created which is giving me a syntax error: CASE…

Perfect this worked thank you

Hi Grant, Thank you for the quick response seems like that did not fix the issue here is a screenshot of the results: any other variation of the code I can try

@GrantSmith Sure here is a sample of my dataset with not all the columns but with a few of them and the key one is the current date I need this current date to represent the snapshot date right now it is showing there is only 1 unique value of May 19 2023 but this dataset ran twice and overwrote the May 12 2023 data that…

@GrantSmith Hi Grant, thank you for your response I tried to follow the steps you sent but after initially running the data flow after adding the time stamp when I go to add in the dataset as an input it is giving me an error saying there is no data in this dataset. Here is the image of it Another question I had is you…

Hi Grant, I am not trying to replace old data however trying to start a process so that each time moving forward from now that the data set I have is refreshed on its schedule appends the data, and not replaces it. This example I feel like is showing me more on how to append historical data as opposed to showing me how to…

Hi Grant, so I only need it to append the data when it refreshes is there a button or option along with the schedule frequency to choose to append the data instead of going down the path of creating a historical snapshot dataset in the dataflow? Something like this image I found this on google and was wondering how to get…

Hi MichehelleH, so if Domo creates another view for a drill-down visual that is consisting of a different dataset will domo charge for this extra view created for this drill-down?

Thank you so much Michelle that did the trick appreciate your insight and the quick responses!

Hi, Michelle, I am trying to sum everything up for seasonal so I don't have multiple lines of the same values for seasonal field and for those measures, I have a cost of sales field and I want to make a calculation that will give me the percentage of the cost of sales of off the grand total for the cost of sales.