Summing with Beast Mode

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

Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.