Top "Cumulative-sum" questions

For questions regarding implementations or algorithms for calculating cumulative sums (also known as running totals).

Cumulative count of each value

I want to create a cumulative counter of the number of times each value appears. e.g. say I have …

r count cumulative-sum
Oracle SQL Analytic query - recursive spreadsheet-like running total

I have the following data, composed of the A value, ordered by MM (month). The B column is computed as …

sql oracle recursive-query analytic-functions cumulative-sum
Excel - How do I create a cumulative sum column within a group?

In Excel, I have an hours log that looks like this: PersonID Hours JobCode 1 7 1 1 6 2 1 8 3 1 10 1 2 5 3 2 3 5 2 12 2 2 4 1 What I would like to do …

excel group-by sum cumulative-sum
mysql error when adding function

The following error is returned when trying to use a MySQL function.. #1418 - This function has none of DETERMINISTIC, NO …

mysql replication cumulative-sum
Pandas Efficient VWAP Calculation

I have the below code, using which I can calculate the volume-weighted average price by three lines of Pandas code. …

python numpy pandas apply cumulative-sum
Python Running Sum in List

Given the following list: a=[1,2,3] I'd like to generate a new list where each number is the sum of it …

python numpy sum cumulative-sum
Creating a cumulative step graph in R

Say I have this example data frame set.seed(12345) n1 <- 3 n2 <- 10 n3 <- 60 times <…

r graph cumulative-sum
SSRS running Total On Multiple Columns?

I am creating one SSRS report in which I have one Tablix the data of that Tablix shown as below, …

reporting-services ssrs-2008 ssrs-tablix cumulative-sum
Select running total until specific SUM is reached

I am trying to select the first n rowid values from the following table variable that will get me as …

sql-server cursor aggregate-functions cumulative-sum
R cumulative sum by condition with reset

I have a vector of numbers in a data.frame such as below. df <- data.frame(a = c(1,2,3,4,2,3,4,5,8,9,10,1,2,1)) …

r dplyr cumulative-sum