Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

 

Merged idea

This idea has been merged into another idea. To comment or vote on this idea, please visit JETESS-I-11 make "sort by sums" easier.

SQL Group By Merged

I would be really nice to be able to the same as you do in SQL  with the command Group by.   

So if I for example need to find top 10 sales items for 1 customer.  then i can't use the flow field sales on Item.   In SQL code I would just select sales, item no,  customer no.   Group by Item No.    Where Customer no = XX

a simular function in Jet would really be nice.  i have had several customers ask for top 10, items sales, per customer, per item category, Per country etc. etc.   

  • Mike Seisbye
  • Dec 5 2018
  • Under Consideration
  • Kim Duey commented
    December 19, 2018 21:44

    I'm thinking this is similar to an existing idea of making 'sort by sums' easier, and will merge this idea with that one. Technically, you can do what you are wanting using the sort by sums technique, as in this article - https://support.jetglobal.com/hc/en-us/articles/115006132828-.

    If I have misunderstood please provide more information.

  • Mike Seisbye commented
    December 05, 2018 15:57

    It could be a "simple" add to the NL function, just like Limit=    you would then choose  Group by  and choose the group by field.     while the only option now is to take out alot of transactions and then calculate. where the group by could reduce the output tremendiously  and then also speed of the report.  And then you didn't need after calculations.