title: Number of Successive Cells of a Same Value in Spotfire
body: <p>I am wondering if it is possible to created a calculated column that will count how many cells of the same value are successive (i.e., next to each other) so that I can divide it by the total number of cells in that column. (I'm only looking at 1's and 0's in the column. Any help or advice would be greatly appreciated as I've been scratching my head over this for a while,</p>
  
  <p><a href="https://i.stack.imgur.com/sF6H5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sF6H5.png" alt="enter image description here"></a></p>
  
  <p>The percentages at the bottom of the columns is simply = (the number of 1's touching another 1) / (total # of rows) --> my end goal</p>