Excel to DOMO running total magic etl or magic etl-python

leeloo_dallas

Can anyone match the exact results from the formulas in my excel spreadsheet?

 

I used the following for beastmode, but the answers don't match what is in the excel sheet so I'm at a loss. 

I only want to replicate this using magic etl, but I don't think it's possible. 

I'm acquainted with the magic etl tool but I don't know how/why sql is so limited in magic etl is. So, "OVER" doesn't work.

 

Contribution:

SUM(SUM(`Users`)) OVER (ORDER BY `Users` DESC)
/
SUM(SUM(`Users`)) OVER ()

 Effort:

This column is dependent on what is displayed on the results from the contribution column.

SUM(SUM(1)) OVER (ORDER BY `Users` DESC)
/
SUM(SUM(1)) OVER ()

 

GrantSmith

 @user052846 

I'd recommend you refer to https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Recreate-2-Excel-Formulas-in-both-Magic-ETL-and-Beastmode/m-p/51726/highlight/true#M9183 since your question was asked there.

leeloo_dallas

Yes, but the answer you provided was incorrect and didn't answer my question. 

 

leeloo_dallas

Is there someone else who can help me with this?

If the result doesn't match the excel file, anything you provide will be incorrect.

Can you please pass this to someone else? 

You've given me countless answers and every single one of them has been incorrect. 

I would really appreciate it if this could be passed to someone else...