Forum Discussion

stephras's avatar
stephras
Frequent Visitor
4 years ago
Solved

Filtering daterange for averagex, sumx, minx, maxx and stdevx

Hi all, I am working on a rather large dataset where I want to calculate measures across the entire dataset/daterange as well as the same measures just for the latest 3 months prior to a customers l...
Need Help
  • stephras's avatar
    stephras
    4 years ago

    For anyone curious or with the same problem. It seems I found the solution with the help from this video (hope it's okay to post it).

    https://www.youtube.com/watch?v=ACvYaXnpyCM

     

    It was a matter of considering it as a rolling average og adjusting the "LastSelectedDate to correspond with my own "last transaction date". It may not be the most elegant solution, but it works for now. 

     

     

stephras's avatar
stephras
Frequent Visitor
4 years ago

For anyone curious or with the same problem. It seems I found the solution with the help from this video (hope it's okay to post it).

https://www.youtube.com/watch?v=ACvYaXnpyCM

 

It was a matter of considering it as a rolling average og adjusting the "LastSelectedDate to correspond with my own "last transaction date". It may not be the most elegant solution, but it works for now.