Best way to do group by/ aggregation in xano without using addon?

Sourabh Jain

I am new to Xano and this seems to be something that should be very easy to do but I am having a little trouble doing this. I tried searching community and documentation but not able to find an answer which doesn't use the addon.  Any help is appreciated. 

I have a table which has schema like this
city,item_name, item_state, id
Bangalore,GoPro, Rented, id12
Delhi, PS4, Damaged, id3132
Mumbai, Riding Jacket, In_store, id1313
Bangalore,GoPro, Damaged , id184
Bangalore, PS4 , Rented, id1345
etc

In output, I want to get count of records grouped by city , item_name & item_state. Something like this  :
City, Product, Stage, TotalCount
Bangalore,GoPro, Rented, 3
Mumbai, Riding Jacket, Damaged, 2
Bangalore,GoPro, Damaged, 1

Ray Deck

You can make your query an aggregation query from the "output" tab of your "query all records" click the pencil, and then where it says "list". You'll get a bevy of summary query options that will serve you well with your next steps. 

Sourabh Jain

This is exactly what I was looking for. 
Thank you Ray.