Filtering on a specific datetime

[thomas-the-tank]

Hello!

I’m trying to create an Explore to allow investigations on the data below.

In the table below, delivery_date and predict_time are measures, and ml_mean and master_mean are measures. 

delivery_date	predict_time	ml_mean	master_mean
2023-03-01	2023-02-16 16:23:28.000	6,620	7,608
2023-03-01	2023-02-16 15:21:40.000	6,608	6,608
2023-03-01	2023-02-16 14:37:50.000	6,601	6,605
2023-03-02	2023-02-16 16:23:28.000	6,730	6,912
2023-03-02	2023-02-16 15:21:40.000	6,715	6,813
2023-03-02	2023-02-16 14:37:50.000	6,711	6,815

We want to be able to pick out individual predict_times, and plot delivery date on the x-axis against one of ml_mean or master_mean.

I can sort-of achieve this by filtering predict_time on days over some period, and then pivot on predict_time - giving me several plots, one for each predict_time.

However, sometimes we would like to plot for specific predict_times that are a large period apart. In this case, I can’t just filter on predict_times I the last e.g. hour or week - there could be thousands of predict_times in between the two desirable ones.

For non-date/datetime dimensions, I can select a number of specific ones, e.g. filtering on whether a field “Month” is one of [“September”, “October”]. How can I do that with a datetime column?