hello,
i have some trouble to find the right solution.
let`s say i have following table:
| id | week | flag |
|---|
| 1 | 1 | 1 |
| 1 | 3 | 1 |
| 1 | 4 | 1 |
| 2 | 1 | 1 |
| 2 | 2 | 1 |
| 2 | 3 | 1 |
what i´m trying to achieve is following result:
Dimension: week
expressions:
- count all ids which have an entry in previous week and this week --> active previous week + active this week
- count all ids which have no entry in previous week but entry in this week --> active previous week + not active this week
- count all ids which have an entry in previous week but no entry in this week --> not active previous week + active this week
Week
| active previous week + active this week
| active previous week + not active this week
| not active previous week + active this week
|
|---|
| 1 | - | - | - |
| 2 | 1 | 1 | |
| 3 | 1 | | 1 |
| 4 | 1 | 1 | |
I struggeling around for a while an couldn`t find any solution. I tried it with aggr function and above function but have no satisfying results.
I hope somebody can help me! it´s really important
Thanks
Stevve
