Hi All,
I have a sample data as below
ID old_val new_val date
101 A B 01/01/2017 10:40:00
101 B C 01/01/2017 10:45:00
101 C B 05/01/2017 09:45:00
Expression -> Count(distinct ID)
But dimension should be old_val, new_val i.e
Without applying date
old_val (min date of old value) as A and new_val (max date of new_val) as B
In case if i apply date as 01/01/2017 then old_Val as A and new_val as C
I used calculated dimension logic as
old_val -> aggr(min(old_val) ID) for
new_val -> aggr(min(new_val) ID) for
I dont know how to apply the max date for above cal dimension
Actual requirement
Logic should be count of ID with first dimension as old_val group by min date , ID and second dimension as new_val group by max date, ID
