NFSharma

Discussions

Some useful Regex statements
ToDo: Use an Edit Data --> Replace Text action in the workflow. Select Regex option and replace by empty string. You can also replace the match with any string you require. Get Handles: (^|\s|[^@\w])+[^@\s]+ Example: Hi @Something how are @you doing David. Result: @Something @you Get Hastags: (^|\s|[^#\w])+[^#\s]+ Example:…
Data Aggregation issue in the Beast Mode Calculation while using Sub-Total and Header Row.
While we use the CASE statements the Aggregation in DOMO first performs SUM and then looks at the condition inside the CASE statement. This means that the following two conditions will provide similar results on the row level, but when the data is aggregated the 2nd condition will only look at the bigger value post SUM()…

Some useful Regex statements
ToDo: Use an Edit Data --> Replace Text action in the workflow. Select Regex option and replace by empty string. You can also replace the match with any string you require. Get Handles: (^|\s|[^@\w])+[^@\s]+ Example: Hi @Something how are @you doing David. Result: @Something @you Get Hastags: (^|\s|[^#\w])+[^#\s]+ Example:…
Data Aggregation issue in the Beast Mode Calculation while using Sub-Total and Header Row.
While we use the CASE statements the Aggregation in DOMO first performs SUM and then looks at the condition inside the CASE statement. This means that the following two conditions will provide similar results on the row level, but when the data is aggregated the 2nd condition will only look at the bigger value post SUM()…