Hi all,
I am pretty new to DOMO and would like to know if there is a hack/tip how I can best calculate data?
Currently I do have an excel-file with many many formulas and was wondering if I can "rebuild" them in Analyzer or better ETL?
Concrete example: There is one column filled with values between 1 and 10. I now want to know how the SUM of all 1s, 2s, 3s and so on is.
Then I want to build 3 new values: the SUM of 9&10, 7&8 and other values and with these results I want to do further calculations, like:
(SUM(9&10) minus (SUM all other values))/(SUM(9&10)+SUM(7&8)+SUM(all other values)) and best to get percent as result.