Looking to replicate a SUM(COUNTIF) formula in Dataiku
I am working on a scorecard in Dataiku and I would like to calculate the percentage of completion in a set number of columns. Basically, I would like to replicate this formula in excel: =SUM(COUNTIF(ColumnX:ColumnXX,"*")/Total Number of Columns) and am having issues. The columns are a mix of strings, integers, and text, however, I just want to see if they are populated period.
Operating system used: Windows
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,993 Neuron
Hi, what does it mean “I’m having issues?”. Are you getting an error? If so can you post it to the thread? How exactly are trying to do this? Are you looking for a code or no code solution? Thanks
-
Hi, I'm not sure what recipe or formula to use to calculate this. From what I can see, all the formulas for mathematical functions in Dataiku need numbers as a value in the cell, not text or string.
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,993 Neuron
https://doc.dataiku.com/dss/latest/formula/index.html#string-functions
I would use the length() and if() formulas in a Prepare recipe.