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])

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Hello, I have an identical situation, and I already managed to rescue the previous value with respect to the date, but I can not do it by differentiating it by city, I do not know if you can explain to me how it was that you used the variable of [prefectureNameE] and earlier([prefectureNameE]) for this case.

Best regards.