Magic ETL

Magic ETL

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

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:

  1. 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.

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

 

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

Comments

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