Basic filtering for slice data based on text

[chocbudda]

I am wanting to create some slices of my data based on a column [Wave].

I tried short cutting with CONTAINS([Wave], "10:10") but this gets expanded to a full date time stamp!?

SO i did a simple [Wave]="10:20 Start - Full Distance"

Now the data appears correct in the Expression Assistant "Test", but from the slice screen if I "Preview" the data it shows no columns!?

[AleksiAlkio · Accepted solution]

How about AND(CONTAINS([Wave], "10:"),CONTAINS([Wave], ":10")) ?

[chocbudda]

Thanks, I will test once back at the desk. It looks like a solution. I was
wondering if there was a means to stop 10:10 being interpreted as a date
time... seems odd