What is the problem or goal the end user is trying to solve or accomplish?
The user would like to have access to the numbers generated from analytical operations performed on Preset level (such as rolling windows), to query them.
How are they solving it currently?
The alternative is to perform the analytical operations on the DB level, so then you can query them. The issue is that this would improve the query complexity.
What is the recommended solution by the Customer?
Provide a way for users to access/query the results of analytical operations performed on Preset level (such as rolling windows), so they can perform additional aggregations on these values (such as SUM()
, MAX()
, etc).