Cumulative Table

[NiTo]

Hello Friends,

In a fix, please help me out.

I have attached the table here.

So, except Sum(new_case), Sum(new_death) and sum(pnew_death), all the other fields have cumulative values.

Now, I need to find the total number of conf_case here. If I give sum(conf_case) the value off course is wrong since it is cumulative data. 

I tried with the following set analysis:

Sum({<[submission_date]={"$(=date(max([submission_date])))"}>}conf_cases)-
Sum({<[submission_date]={"$(=date(min([submission_date])))"}>}conf_cases)

But the end result is zero.

Plus I need to find the conf_case data wrt current week and here too result is zero.

plus I need to find the sum(conf_case-conf_death) and the sum(conf_death).

Please help.

HAVE A GOOD DAY..

CHEERZZ

[vinieme12]

can you post some dummy data in excel with expected output?

[NiTo]

Hi Vini,

Thanks for your reply.

The data correspoding to date 1/24/2021 is the value I need for conf_case, conf_death  as the field data is cumulative data except for the field (new_case), (new_death) and (pnew_death).

I need following things:

1) Total of (conf_cases-conf_death), plus current week  (conf_cases-conf_death) count

2) Total conf_cases

3)Total conf_death plus total conf_death for current week