Running Median/Running Standard Deviation

Question & Answer
, ,
1

I know there are running calculations that we can use in Quicksight, but I am trying to do a “Running Median” and a “Running Standard Deviation” calculation. Is this something that is possible in Quicksight?

2

@manbig ,

Can you load a sample data to Arena (NEW - QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community) and explain what is the input and expect output ?

Kind regards,
Koushik

3

Attached is some sample data (Sample Data) I am working with as well as a screenshot of the outcome I am looking to accomplish!
End Result

4

I was able to figure it out after using the ‘WindowSum’ Function!