Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a DDBB table in which the columns are in the format as follows: YYYY-MM-DD HH:MM:SS.S for example 2020-02-28 10:23:50.240
Column A (Hora Peticion) is Timestamp for order and Column B is timestamp for delivery (HoraDescarga) . The delivery time is =interval(HoraDescarga-HoraPeticion)
My aim is to plot which values are above a certain time for example 00:10:00 - ten minutes and which are below this time. Ending up with a histogram as a result with "OK" values and "NOK" values for the total deliveries.
What expressions can i use inside the plot chart so it appears this way? I suppose one expression for "OK" and one for "NOK" . I manage to get the intervals with : =interval(HoraDescarga-HoraPeticion) but need to filter these results.
Thanks
Hi, you can try with:
If(HoraDescarga-HoraPeticion<1/24/6, 'OK, 'NOK')
Hi, thanks for the reply.
How would the count function work here?