Core Designer Certificate

[mahatibharadwaj]

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

[SeanA]

Hi @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).

[mahatibharadwaj]

They are not 'string'. They are 'integer'.

[mahatibharadwaj]

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.

[mahatibharadwaj]

what are the total number of columns in the aggregated dataset?