Date Columns is Returning Mixture of Date and Text Formats in the CSV Attachment in Scheduled Report
ISSUE: The date Columns is Returning Mixture of Date and Text Formats in the CSV Attachment in DOMO scheduled Reports. I need them in text format and the correct should be the (e.g. 11-14-2023 10:00:00). Some are appearing correctly but some are giving me in date format in the same column (see screenshot). Is this a known…
Can you convert Date to Text in DOMO?
Trying to find online but could not. Main purpose is that when the csv attachment in schedule reports get sent, I want the report to have no "T" stamp. Current: 2023-11-27T00:00:00 Change to: 2023-11-27 00:00:00 If you guys have other alternatives, please let me know. Thank you.
Removing Duplicates with Condition
Hi All. My dataset have a lot of duplicate rows so I wanted to use "Remove Duplicates" in ETL based on the Shipment ID. However, there are some products that are hazardous. I want to have the hazardous row left remaining when I remove the duplicates if there is a mix of Haz and non-Haz. Any function or use of "Rank &…
Guidance on Proper Beast Mode Syntax for Nested Cases
Hi everyone. I am trying to build-up a series of "cases" that will identify if our shipment is either "Hit", "Miss", or "Risk" in that order. "N/A" if shipment does not satisfy any of the 3. We have created a logic for each identifier. It is showing as validated but we are not getting the expected results with a lot going…
What is the syntax to add a "if contains the following" in my logic
Hello. I want to create a logic that replace those rows that don't have both AP and MA in the name as # and keep untouched those that have. AP is always in the 1st and 2nd respectively. Then MA is in the 5th and 6th. My logic seems to be not working. Can anyone help? --------------- (Case WHEN `sap shipment 1 tariff id` <>…