6.10 Filter by group’s aggregation value
We have an Excel table for the daily sales of products:
We want to find out the date when the total daily sales amount exceeds 300,000:
=spl("=E(?1).groups(OrderDate;sum(Sales):TotalSales).select(TotalSales>300000)",A1:C2401)
https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1654307849156
https://c.scudata.com/article/1654391166534
SPL Official Website 👉 https://www.esproc.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.esproc.com
Discord 👉 https://discord.gg/2bkGwqTj
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/
