Percentage of Total

Reply
Highlighted
Yellow Belt

Percentage of Total

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

White Belt

Re: Percentage of Total

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

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