hi there, this is super helpful! i was wondering if you’d know how i could do a window sum (shown as a graph) using table across? would be great if you could advice based on your expertise!! thank you :)
Hey Vivica. I'm not sure I fully understand your question. The window sum function is essentially calculated as "table across" since it takes the last X data points. Since it's a table calculation, you aren't going to be able to do any additional manipulation like running sum etc on top of it. If you expand on your question, I'll try and help.
Thanks. I was just creating something like this actually. I was searching to find a solution to the first part of the graph that is not a full window range. Nice trick with the IFF function, however for my use I really need to have it filled in with the window values. Do you know how to do this? So the window values are not affected by the time filter you have in the Viz? So basically allowing it to aggregate further back than what you are showing. Cannot find a good solution to this online I think.
Hey Kasper. If you want to show all your data points in the viz, then you can simply use the window_sum function on it's own without including the IIF piece.
![Megan Thee Stallion - Neva Play (feat. RM) [Official Video]](http://i.ytimg.com/vi/TpYTyAaTRts/mqdefault.jpg)
hi there, this is super helpful! i was wondering if you’d know how i could do a window sum (shown as a graph) using table across? would be great if you could advice based on your expertise!! thank you :)
Hey Vivica. I'm not sure I fully understand your question. The window sum function is essentially calculated as "table across" since it takes the last X data points. Since it's a table calculation, you aren't going to be able to do any additional manipulation like running sum etc on top of it.
If you expand on your question, I'll try and help.
Thanks. I was just creating something like this actually. I was searching to find a solution to the first part of the graph that is not a full window range. Nice trick with the IFF function, however for my use I really need to have it filled in with the window values.
Do you know how to do this? So the window values are not affected by the time filter you have in the Viz? So basically allowing it to aggregate further back than what you are showing.
Cannot find a good solution to this online I think.
Hey Kasper. If you want to show all your data points in the viz, then you can simply use the window_sum function on it's own without including the IIF piece.