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.