Forum Discussion

owlet0214's avatar
owlet0214
Helper I
6 years ago
Solved

Difference from previous cell

Hello,   I want to make a custom column that calculates the difference from the previous cell. The testedPositive is not the increasing number of people on that day, but the cumulative total up to...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Unless it is prefecture columns throwing things off I would think:

    diff = [testedPositive] - maxx(filter('prefectures4',[prefectureNameE]=earlier([prefectureNameE]) && [Last date] <earlier([Last date])),[testedPositive])
owlet0214's avatar
owlet0214
Helper I
6 years ago

Thanks a lot !

 

I haven't gotten the expected number yet, but I think it's getting closer to the correct answer.

I will try a little more.

 

I use below.

 

Last date = maxx(filter('prefectures4',[prefectureNameE]=earlier([prefectureNameE]) && [YYYYMMDD2] <earlier([YYYYMMDD2])),[YYYYMMDD2])


diff = [testedPositive] - maxx(filter('prefectures4',[prefectureNameE]=earlier([prefectureNameE]) && [YYYYMMDD2] <earlier([Last date])),[testedPositive])

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
Unless it is prefecture columns throwing things off I would think:

diff = [testedPositive] - maxx(filter('prefectures4',[prefectureNameE]=earlier([prefectureNameE]) && [Last date] <earlier([Last date])),[testedPositive])