Summing with Beast Mode

Reply
Green Belt

Re: Summing with Beast Mode

I think a two-step approach would be worthwhile here.  First, you could create a beastmode calculation that would show the first year that a given customer id was present in the data you are working with.  Then, after that, you could create a table for all customer ids with a first purchase year of 2011.

"When I have money, I buy books. When I have no money, I buy food." - Erasmus of Rotterdam
Major Blue Belt

Re: Summing with Beast Mode

According to Tyler R., this is the solution:

 

“Yes, you can sum an entire column in Beast Mode, creating a new column with the SUMIF of another column. However, the specific use case you provided would first require some pre-aggregation of the data prior to the building of the card. This would require the use of DataFlows. If you need assistance with doing this in DataFlows, please let us know.”

View solution in original post

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!