Sigma Community

How to Drop a Row

Sigma Formulas and Functions

ztrean August 5, 2020, 7:53pm #1

Is there a way to create a new column that drops a row from a different column? Just like what is pictured below:

Ryan August 5, 2020, 7:54pm #2

Yes! You can use the Lag() function to accomplish this.

system automatically bumped October 11, 2020, 7:43pm #3

system automatically bumped October 25, 2020, 3:22am #4

system automatically bumped November 9, 2020, 12:51pm #5

system automatically bumped November 29, 2020, 6:28am #6

system automatically bumped December 18, 2020, 8:44am #7

system automatically bumped January 7, 2021, 7:09am #8

system automatically bumped January 27, 2021, 3:49pm #9

system automatically bumped February 18, 2021, 1:39am #10

system automatically bumped March 11, 2021, 6:32am #11

system automatically bumped April 1, 2021, 3:45pm #12

system automatically bumped April 23, 2021, 5:43am #13

system automatically bumped May 15, 2021, 1:06am #14

system automatically bumped June 6, 2021, 7:32am #15

system automatically bumped June 29, 2021, 4:05am #16

system automatically bumped July 21, 2021, 8:37pm #17

system automatically bumped August 13, 2021, 4:53pm #18

system automatically bumped September 6, 2021, 4:48am #19

system automatically bumped September 29, 2021, 3:18pm #20