Filter after aggregate function
I have a list of stock transactions that I want to run an api call to aggregate them and only return the currently active holdings. In other words if the sum of all the transactions for a certain company returns a quantity of 0, I would like to filter it out. I can understand how to filter the inputs but not the outputs as simply.
Other than running a bunch of conditional loops, and creating new tables to try and filter this out. Is there a more efficient way to filter the results of the initial query? When I tried doing this before I was sort of able to make a query that worked but it sometimes timed out because the whole function stack just took too long.
Answers
-
Hi,
You can use update variable to modify the result of the query, You might want to look at high order filters, they a need a bit of js code but in your case it should be very simple one, other way is to use array function to make additional filtering on the initial list from your query.
Categories
- All Categories
- 53 ? Announcements
- 47 ? Releases
- 37 ? Welcome
- 983 ? Help! I'm a Noob
- 125 ? No-Code Front-Ends
- 633 ? Working with APIs
- 439 ? Transforming data
- 126 ? Connect Xano to ...
- 50 ?? Find an Expert
- 348 ❓Other questions
- 35 ? Security
- 22 ✂️ Snippets
- 19 ? Showcase
- 7 ?️ Xano Chatter
- 62 ? Video Tutorials
- 171 ? Request a feature
- 229 ? Report a Bug
- 19 ? Templates & Extensions
- 7 ? Feedback