time series - how can i work out the percentage of rows with matching values in 2 different columns? -

time series - how can i work out the percentage of rows with matching values in 2 different columns? -

i'm trying find out percentage of users homecoming site comparing 'joined' date , 'last seen' date.

in more literal terms, have table looks bit this:

| username | joined |last seen | |----------|:-------------:|---------:| | user1 | 3434626 | 4134526 | | user2 | 3434668 | 3434668 | | user3 | 3434646 | 4134579 |

and want find percentage of users have different bring together date lastly seen date.

once using spreadsheet, it's quite simple. know primitive, may simple way accomplish desired result.

subtract joined lastly seen [=c2-b2] receive either 0 same, or positive value if not.

count amount of cells value greater 0 [=countif(d2:d4,">0")]

divide count of cells in row [=count(d2:d4)]

final cell formula: [=countif(d2:d4,">0")/count(d2:d4)]

format cell percentage.

google doc of method here - https://docs.google.com/spreadsheets/d/1eyg0gggdkae-dzzmpp4sbipmlqf5vkydhwvh54myy38/edit?usp=sharing

time-series correlation