Magic ETL

Magic ETL

Beast Mode Question

I have three column, first one is how many we gained this year, second one is how many we lost this year, and last column is total. I applied a filter, filter through this year the problem is I want total column go beyond this year, in another word, the filter won't affect it. Can I do this in beast mode, I try create a ETL but get this error message "Aggregate functions are not allowed in this context: 'SUM'. domo"

What's the best way to solve this?

Tagged:

Answers

  • you can try and use a fixed function with a filter none. Try something like

    1. SUM(SUM(`Total`) FIXED (FILTER NONE))
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • I apologize for the confusion. Each column represents a separate store, so I would like to see the total for each individual store, rather than the combined total for all stores.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In