Mission isn't validate

Mission: DATA MINER
Task: Retrieve Data With Aggregate Functions

hello I don’t undestand, I was sur this mission was validate, but in fact no!!
the video need an update …
could you help me?

Please, describe your problem here.

Hi Franck,
it is true, when the video was recorded the aggregate function was not yet present in REST Console.
To complete it is now easier:

  • Select on the Country table;
  • Click on “Aggregate Functions” under the “Where” field, in this way it will open a small menu at the bottom with everything you need;

Then set the rest as the mission asks you and that’s it!

At first I too panicked because I couldn’t find what was described in the video :joy:

I hope I was helpful,
Marco

hello and thanks
That was exactly what I did

Hello @Franck_RICHARD

The mission description does not specify that the query must include objectId. But I see in your screenshot that it is included in the query.
It is important to follow the instructions precisely as they are written. For example, if the mission statement says that the query should only include a certain property, then no other property should be in the query.

Regards,
Inna

Hi,

I have a similar issue. Looks like I have done it as requested, but still, the task is not completed :frowning:
Maybe you could just add some comments to the task description

Hello @Arkadiusz_Kumpin,

Try using the ‘objectId’ column for the ‘Count’ aggregate function, then everything should work out.

Regards, Nazar

Tricki one, but at least I got more familiar with the support forum :smiley:

Thank you, now it worked and I can move forward.