Aggr in Expression question

[zfonline7888]

Hi,

I have the following inline table:

load * inline

[

ID, Date, Status

1, 8/3/2018, Existing

2, 8/3/2018, New

3, 8/3/2018, Existing

4, 8/3/2018, New

5, 8/3/2018, New

6, 7/3/2018, Existing

7, 7/3/2018, New

8, 7/3/2018, New

]

;

Please help to create the following pivot table:

I am using the following expression for Distribution:

count(aggr(Count(ID),Status,Date))/count(aggr(Count(total ID),Status,Date))

But get 100% in all values in Distribution.

Thank you very much.

[Digvijay_Singh]

May be this -

count(aggr(Count(ID),Status,Date))/count(total aggr(Count(total ID),Status,Date))

[zfonline7888]

Thank you for your reply, but your answer is not correct.

[Digvijay_Singh]

TRy removing outer count from numerator, else need to try with sample

‌

[cengizeralp]

this maybe solve

count(ID) / count(total <Date> ID)

[zfonline7888]

No, you need use Aggr function to group the Date.  Thanks.

[cengizeralp]

Hi Mike,

Did you try it? Why do we need to use Aggr function?