I'm using the Search Users report in the Twitter connector to pull the number of followers for a particular user. I have it set to run daily and append the new data, which gives me the running total for twitter followers for the given user. I'd like to create a beast mode calculation that will give me the number of new followers on a daily basis so that I can create a chart that shows new followers by day. In order to do that I need to look at how many followers the user had on a given day based on the "_batch_last_run_" date and subtract the number of followers from the prior day. I can calculate it for today versus yesterday, but I'd like to be able have it calculate for all days in the date range that the Domo user defines. Any ideas on how to create a beast mode calculation that will do that? I'd also be open to calculating it via a dataflow.
Thanks!