Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this -
count(aggr(Count(ID),Status,Date))/count(total aggr(Count(total ID),Status,Date))
Thank you for your reply, but your answer is not correct.
TRy removing outer count from numerator, else need to try with sample
this maybe solve
count(ID) / count(total <Date> ID)
No, you need use Aggr function to group the Date. Thanks.
Hi Mike,
Did you try it? Why do we need to use Aggr function?