Hi,
I am having a hard time with this simple task.
I have a column in my dataset called Lane, which is formatted as followed 'PointA>PointB.'
I am trying to create a card on a dashboard that if PointB is selected it will filter all lanes that either start with PointB or end with PointB (exmple 'PointA>PointB' would show up and 'PointB-PointC' would show up.)
Ive tried creating a beastmode which is called CitySelector which its just the shipperCity column. I then tried to create this beastmode but its only getting lanes that start with whats selected in the CitySelecor Filter. Any Ideas why?
CASE WHEN Lane
LIKE CONCAT('%', CitySelector
, '%') THEN 'Y' ELSE 'N' END
Thanks for the help!