Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Could you provide more information on what metric are you interested in? The screenshot you provided is just a log file that shows an error, but it doesn't give any relevant information as far as I can see.
About finding the sum of a column in the prepare recipe, are you looking to create a new column with this value, or you just want to know what is the sum of a column?
Can you see the screenshot below?
I basically need a method to calculate a row value divided by another column's sum in prepare recipe, something quite simple and common to do on excel. I know this is easy with python but this is for a user who does not code and it'll be surprising to find out doing something so simple in excel is not feasible easily using visual recipes.
Yes, I can see the screenshot and I understand now your use case.
Apparently, there is no way to access the metrics values from a visual recipe, at least I was not able to find anything in the docs.
Also, and again I might be wrong, the formula language available for some visual recipes do not include functions to calculate statistics from a column (sum, mean, std, etc), in a way that its results can be used to be applied to the cells. All operations, and this apply apparently also to the python option within the prepare recipe, are row by row.
I was able to find a solution using only visual recipes, but I find it not too elegant or practical. Given a dataset with columns A, B, C, where we want to dived the B rows by the sum of all the rows in column C:
And that is it, you have what you needed. But I agree, it is not as simple as with excel.
Maybe a dataiker could provide more input? @CoreyS ?