Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have table like this,
UID | prd | time |
---|---|---|
2 | 0.0016 | 7 |
3 | 0.0024 | 7 |
2 | 0.0032 | 14 |
7 | 0.0018 | 7 |
4 | 0.0073 | 14 |
1 | 0.0049 | 14 |
1 | 0.0015 | 7 |
2 | 0.0064 | 21 |
2 | 0.0009 | 28 |
3 | 0.0085 | 14 |
3 | 0.0071 | 21 |
3 | 0.0028 | 28 |
4 | 0.0046 | 21 |
7 | 0.0058 | 14 |
7 | 0.0069 | 21 |
1 | 0.0084 | 21 |
I want to have a chart which has [time] as dimension and three expressions
log(log(1/(1-prd)))
15+log(prd)
prd
There is a defined variable vUID and it will used for set analysis for expressions, such as:
log(log(1/(1-({<[UID]={$(vUID)}>} prd))))
15+({<[UID]={$(vUID)}>} prd)
({<[UID]={$(vUID)}>} prd)
Just don't know what exact syntax to apply this kind of set analysis to those expressions.
Thanks,
Josh
May be this:
log(log(1/(1-Only({<UID = {$(vUID)}>}prd))))
15+log(Only({<UID = {$(vUID)}>}prd))
Only({<UID = {$(vUID)}>}prd)
May be this:
log(log(1/(1-Only({<UID = {$(vUID)}>}prd))))
15+log(Only({<UID = {$(vUID)}>}prd))
Only({<UID = {$(vUID)}>}prd)