Count for status of last period

[#1]

Hi everyone,

I have 3 dimensions :

- STATUS (A, B, C...) ,

- PERIOD (1, 2) 

- PROJECT (1, 2, 3, 4......)

When I filter on 1 STATUS only, I want a pie chart to appear to give me the number of projects by their status during last period

So my pie chart has a dimension STATUS

and an expression :

count({<[STATUS]=,PERIOD = {'$(period_1)'}, PROJECT=P({<PERIOD = {'$(period)'}>} PROJECT) >} distinct PROJECT)

But my problem is that my 10 projects in status A in period 2 were in period 1 :

- 8 in status A

- 1 in status B

- 1 didn't exist

Any idea how to make also appear this last one

(I must precise that :

     - I don't want all the other status without project to appear in my legend, and

     - I want ta custom name like 'NOT YET CREATED' to appear in my legend.)

Thank you all for your help !!!!!

[#2]

anyone ?

[#3]

I searched and I think the expression to calculate how much didn't exist is :

count({<PERIOD = {'$(period)'}, PROJECT=E({<PERIOD = {'$(period_1)'}>} PROJECT) >} distinct PROJECT)

But how to mix those two expressions in the same graph ?