1 Reply Latest reply on Jul 11, 2019 9:18 AM by Deepak Rai

    data shifted after calculated field

    Avi Cohen

      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