adityak
Data Storage
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Retrieving previous rows data in Sisense Data Modeling
Hello Michael, Thanks for the response. Currently, we implemented the similar approach to our use case. For this to work, we have to create multiple table relating to each other and union all in the end to make the resulting table. Also we don't have any base table for this, even the initial row is being created as a custom query. Just checking if there's any alternative solution so we can make up the data into a single table instead of having every row being referred to the previous table and ending up huge number of tables. Thanks, Aditya1.4KViews0likes0CommentsRetrieving previous rows data in Sisense Data Modeling
Hello all, I have a requirement where we need to get the value of last row's ending balance as beginning balance of the current row and this process should carry on for next 100 rows. And we don't have any base table for this and everything is build from the Custom table. Currently, we are creating multiple tables for references, but ended up having GBs of data in Cube. So, is there any possible solution for this challenge? Thanks, Aditya1.4KViews0likes2CommentsLAG/LEAD in Sisense Data Modeling
Hello all, I want to know whether there's a possible alternate for Lag and Lead functions in Sisense. I want to design a table where the row values are to be calculated based on the previous row values. The example of the model I want create is attached in the image. Thanks, Aditya1.7KViews0likes1Comment