Percentage of Total

SiGill1979
SiGill1979 Member
in Magic ETL

Hi

How do you create a column in ETL that sums an entire column?

I am trying to create a card that gives percentage of total, from looking at other posts the way to do it would be to create a column in ETL which gives the Grand Total of an entire column, example attached, then create a beast mode in a card.

But I can't figure out how to create a Total column.

Any help would be appreciated

Thanks

Simon

Comments

  • MichaelB
    MichaelB Member

    The only way I have found for creating a total column is to split the data as below add a single constant to every row you want to include in your total. Then group by the constant and create a new sum column then rejoin on the constant. You can then eliminate the constants and there you go.

     

    Example.PNG

Categories