I am trying to create a calculated field, using a lead/lag function, found here. i can get the calculation working but afterward a null row is added to my data and it throws off all data. Is there a way I can exclude this null value row.
Also when I create a calculated field, I cannot view the output of the values in the data source. how would I be able to see the raw values (to ensure the formula I used was correct) I was able to view a graph but i would prefer to view raw data