Looking to replicate a SUM(COUNTIF) formula in Dataiku

Katalin

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

Turribeach

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

Katalin

https://community.dataiku.com/discussion/comment/44560#Comment_44560

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

https://doc.dataiku.com/dss/latest/formula/index.html#string-functions

I would use the length() and if() formulas in a Prepare recipe.