Dear Community,
the schema for the database is as follows:
order id | date of production | date of material demand | date creation of material demand | time creation of material demand
24555 01.02.2018 14.02.2018 02.02.2018 14:45
24555 01.02.2018 16.02.2018 03.02.2018 12:01
24555 01.02.2018 18.02.2018 03.02.2018 14:03
24555 01.02.2018 23.02.2018 01.02.2018 18:20
24555 01.02.2018 22.02.2018 01.02.2018 18:40
in my table the Dimension should be "date of material demand" and the value should be the last data set
order id | date of production | date of material demand | date creation of material demand | time creation of material demand
24555 01.02.2018 22.02.2018 01.02.2018 18:40
like
if(date creation of material demand = date of production, then take the latest value of "date of material demand" according to the time (last column)
