filter by maxiumum [and minimum] payment size and sum [small] payments over different payment size ranges

[AndySchroder]

Describe the feature

With Distributed Charge (http://andyschroder.com/DistributedCharge/) there are many small payments made as long as power to your building is on or your car is charging. There can be thousands of payments over the course of a month. With Zeus, we now (#1100) have the ability to filter transactions by a minimum size (which can be used to hide all of these small transactions), but it would also be nice to filter by maximum size (to show the small payments only).

Taking it one step further, it would be nice to also be able to aggregate payments within the filtered size range and then sum them based on a common memo and/or destination node public key, and then report sums for different intervals (such as hour, month, day, and year).

These summed intervals could then be optionally displayed along with "normal" transactions. Then, pressing on the summed payments would show the individual payments within the interval.

Related: #83 suggests filtering by memo, but doesn't mention aggregating the small payments over an interval.

I can imagine that there are many other applications where this same feature would be very useful, for example, "Podcasting 2.0", video streaming, audio streaming, VPN services such as https://lnvpn.net/, etc..

[AndySchroder]

lightningnetwork/lnd#7626 might help make this request more feasible?

[AndySchroder]

Would like to add a bounty of 50,000 sat for fixing this issue.

[myxmaster]

The thing is, with lots of payments, the retrieval of the complete data set (all payments) can take a long time (and creates high server load for the backend), which is why we need pagination. So we need to think about how to integrate that feature in the UI. Users should understand that it can take a while to create that kind of reports -> it should not look like just another filter/default feature on Activity screen.