Core Designer Certificate

Options
mahatibharadwaj
mahatibharadwaj Dataiku DSS Core Designer, Registered Posts: 6 ✭
in Academy Discussions

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

· Share on FacebookShare on Twitter

Answers

  • Sean
    Sean Dataiker, Alpha Tester, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer Posts: 168 Dataiker
    Options

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

    · Share on FacebookShare on Twitter
  • mahatibharadwaj
    mahatibharadwaj Dataiku DSS Core Designer, Registered Posts: 6 ✭
    Options

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

    · Share on FacebookShare on Twitter
  • mahatibharadwaj
    mahatibharadwaj Dataiku DSS Core Designer, Registered Posts: 6 ✭
    Options

    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.

    · Share on FacebookShare on Twitter
  • mahatibharadwaj
    mahatibharadwaj Dataiku DSS Core Designer, Registered Posts: 6 ✭
    Options

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

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…