Aggregation function

Console Missions
1

Mission: DATA MINER
Task: Retrieve Data With Aggregate Functions

Please, describe your problem here.

I am experiencing some difficulties with the Data Mining last track. I have been working hard to complete the track, but I seem to be stuck and unable to move forward.

I have provided a link to my solution here

(https://selectsort.backendless.app/api/data/Country?property=Count(`objectId`)%20as%20CountryCount,Continent&property=Min(`LifeExpectancy`)%20as%20MinLifeExpectancy&groupBy=`Continent`)

i think its need backendless team to solve it as the UI have been changed and there is a button for aggregation function already

Thank you for your time and support.

2

Hello @ALI_ALGHAMDI!

Please make sure that the Country table exists in your application. If it does not exist, you can download it from this link and import it using Manage->Import->Data Tables.

After that you can use this query to pass the mission:

https://selectsort.backendless.app/api/data/Country?property=Continent&property=Count(%60objectId%60)%20as%20CountryCount&property=Min(%60LifeExpectancy%60)%20as%20MinLifeExpectancy&groupBy=Continent

Let me know if you have any questions or if there’s anything else I can help you with!

Regards,
Alexander