Core Designer Certificate
Hi
I am doing the hand-on part in the core designer certificate. In step 10, what should be the total number of columns? Also, I am able to do aggregate on only 4/7 'descriptive' columns. For some reason, I do not see the 'Avg' aggregate option for those 3 columns. Can you please help?
Thanks
Answers
-
Sean Dataiker, Alpha Tester, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer Posts: 168 DataikerHi @mahatibharadwaj
, without knowing more, it sounds like you do not have the correct storage types for 3 columns. If for example, a column is stored as a string, you wouldn't be able to calculate the Average when grouping. If this is the case, perhaps something went wrong earlier in your Flow (such as the Join). -
They are not 'string'. They are 'integer'.
-
All columns in the original schema after 'join' are 'decimal'. But in this aggregation step, the three computed columns are detected as 'string'. Please help me to rectify this step.
-
what are the total number of columns in the aggregated dataset?