Best Of
Re: Question on breakeven formula
I would suggest pivoting the data in Magic ETL so each day is a row and then you can use the rank & window tile to create a running total. This will allow you to easily determine which day you broke even on. You can then pivot it back to your original format if you really wanted to. However, I would instead suggest keeping it in the day/row format and then using the pivot table chart to display it in the format of your screenshot.
Creating rolling averages in Magic ETL and de-emphasizing recent dates
At the most recent Domo Community Virtual Meetup, Michael Christensen demonstrated how to build out 90 day rolling averages using MySQL while also de-emphasizing the most recent dates in a multi-line chart.
I was inspired the demonstration and wanted to create the same thing, but using Magic ETL. In this video, I walk you through how to do it. I hope you find it helpful
Re: Salesforce ExactTarget (Marketing Cloud) Connector
Did you try a different token to see if that fixes it?
Re: Trailing Totals Deep Dive
@marcel_luthi they key to consecutive days is to add the Domo Dimension Calendar which has a row for every day. Joining your data to that will ensure consecutive days.
Re: Using Magic ETL to extract a substring using Regex and excluding remaining strings
@NDoyle ,
Glad it helped! I know the stubbornness route well so wanted to save you a headache.
Please mark my solution as helpful when you can
Re: Using Magic ETL to extract a substring using Regex and excluding remaining strings
You'd need to do it in a formula tile instead of the replace text tile with something like this:
CASE WHEN REGEXP_REPLACE(`Project Name`,'^.*\b(AR-\d{5})\b.*$','$1') <> `Project Name` THEN REGEXP_REPLACE(`Project Name`,'^.*\b(AR-\d{5})\b.*$','$1') END
or alternatively:
CASE WHEN REGEXP_LIKE(`Project Name`,'^.*\b(AR-\d{5})\b.*$','$1') THEN REGEXP_REPLACE(`Project Name`,'^.*\b(AR-\d{5})\b.*$','$1') END


