I am trying to replicate the following formula(s) in excel in DOMO. I hav ebeen using Magic ETL but apparently the mysql library is very limited.
I've provided an example of my dataset that I want to replicate in DOMO using magic etl
Then, if possible, I also want these same formulas replicated in Beastmode.
Formulas in Excel include:
Contribution: =SUM(A$2:A2)/SUM(A:A)
Effort = =F2/MAX(F:F)
Thanks so much for your help.
I've gotten through some of it, but I'm pretty confident there's a less complicated means of doing it out there.