Calcuated Column for Adjacent Cells of a Specific Value in Spotfire -

i wondering if possible create calculated column count how many cells of same value (and value) successive (i.e., next each other) can divide total number of cells in column. or advice appreciated i've been scratching head on while. update previous question posted (link below)

this new question has key differences below: (1) want count number of "blue" cells adjacent other "blue" cells (2) (over) each site

previous question here: number of successive cells of same value in spotfire

you'll need insert rowid column again, after formula work you. can test making siteb, depth 1 = blue have 2 "blues" touching in different sites.

if(([color]="blue") ,  (([color]=first([color]) on (intersect([site],next([rid])))) or ([color]=first([color]) on (intersect([site],previous([rid]))))),1,0)