Hi Experts,
I have attached the sample data.
the sheet has raw data and also required format
required is the summary level data. in the summary, i need to exclude vehicle id =CSD
also, i have to take the minimum of the vehicletime if i have multiple vehicles per single product number.
for eg. if i select product number 1611010010, then my percentiles should display 01:38:26.
How can i do this.
can someone please help me with the expression.
my current expression is
INTERVAL(Fractile({<[vehicle id]-={'*CSD*'}>}(vehicletime-timeconnect),0.50))
