arzconci

Hi friends - Seems the quality of source data is leading to this issue. This makes the date_format and replace functions not working as expected. Thank you for the help. I used these functions in my other reports related to dates and has worked.

in Date Columns is Returning Mixture of Date and Text Formats in the CSV Attachment in Scheduled Report Comment by arzconci November 2023

Hi Grant. Just tried it. It's returning same issue. I created new column.

in Date Columns is Returning Mixture of Date and Text Formats in the CSV Attachment in Scheduled Report Comment by arzconci November 2023

@GrantSmith thank you sir! it worked! Did the ranking to put HAZ on top and when I removed duplicates, it's the one getting selected. :)

in Removing Duplicates with Condition Comment by arzconci February 2023

Thanks Michelle and Grant. Anyways, going back to the original topic, for the "Miss", @MichelleH, there are actually only 2 groups of conditions. I need to have output as Miss if either lines 1-5 or 9-13 is satisfied. So based on your advice, I can also just group them via parenthesis? Sample below ( when `actual arrival…

in Guidance on Proper Beast Mode Syntax for Nested Cases Comment by arzconci November 2022

@MichelleH Thank you for the advise Michelle! Noted and will update my DOMO logic on it. Sorry, basic question, how do you paste Beast Mode syntax in that format?

in Guidance on Proper Beast Mode Syntax for Nested Cases Comment by arzconci November 2022

Hello @MarkSnodgrass and @GrantSmith Thank you for your feedback. Tried both and was able to make it work. First time to try "Like" also so thanks for the knowledge share.

in What is the syntax to add a "if contains the following" in my logic Comment by arzconci November 2022

arzconci Member

Comments