Hello nnguyen95
Did the information provided by Liliia_DevX help you? If so, please mark it as the solution so that other users with the same question can find the answer. If not, please let us know so we can continue to help.
Thank you.
Hello,
Unfortunately this solution was not exactly what we were looking for. We ended up using a workaround and calculating the metrics before and after the change made on the Config Start Date by pre-calculating these in SQL using the LAG function.
However, we'd like to see if there would be a way to solve this without pre-calculating in SQL. Is there any functionality in the Sisense formula builder that could potentially emulate the LAG function in SQL? This is what we were hoping to achieve using the PREV function, but as noted in Lily's response this is not how the PREV function works in actuality.
Please let me know if any further information will be needed.
Thank you!
