Dynamic dimension

[dwhanand]

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