Calculate weekly closures

[#1]

Hi I am looking for some help on below. Scenario is that I want to capture weekly closures. I have data and desired output as per attached can you please throw some ideas.

Thanks

Mahesh

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[maxgro]

LOAD

  Date,

     Status

FROM

Example.xlsx

(ooxml, embedded labels, table is Sheet1);

dimension          =pick(match (week(Today()) - Week(Date),0,1,2,3), 'Current', 'PW', 'PPW', 'PPPW')

expression        count({$ <Status={Closed}>} Status)

                        count({$ <Status={Open}>} Status)

[#4]

Thank you guys for the idea