Would be great if we were able to select more than one item in a filter when used as an input selector
slice(A:A) returns all values in the input selector - Mon -> Sun, if we select Mon at B:B the $ var passed is Monday
When applying a hidden data filter with a match we would get the result of 1 only for Monday
It would be great if I could multi-select, Mon, Wed, Fri (maybe a checkbox) where the filter is applied as AND conditions.
B. Another idea is to have a slider where you can drag two sliders to use as between values.
Start time Slider 1 range - 00:00 - 23:59 End time Slider 2 - 00:- 23-59
By dragging the slider we can set the start time to say 01:00 and drag the end slider to say 03:00, convert to epic and the use a between filter to allow the user to return the values in between
Sliders could be set to a range read from cells.
Just my suggestions