Best Of
Re: Group By Condition in beast mode
@Ganesh_Naren If your beast mode is an aggregate, the Group by is determined by whatever dimensions are used in your card. For example if you have a beast mode SUM(`Sales`) in the Y-axis of a bar chart the values will group by whatever dimension you have in the X-axis, whether that be Month, Customer, Sales Rep, etc. This takes the place of the SQL "Group by" condition and allows a higher level of flexibility with your visuals.
For anything more complex than that, I suggest you check out FIXED functions.
Re: Using RegEx to split a column at a delimeter
You can use a formula tile and the REGEXP_REPLACE function to get just the value of your match. There isn't a regex substring function so you essentially have to match the entire string and then replace it with your value:
REGEXP_REPLACE(`field`, '^(?:[^_]+).*$', '$1')
Re: Using RegEx to split a column at a delimeter
Have you looked at the Split Column tile in Magic ETL?
Re: filter issues
That is odd. I would suggest creating a beast mode that results in numerical values to put in your sorting. For example, I would do something like this:
CASE WHEN Preferred = 'Yes' THEN 1 ELSE 0 END
Put this beast mode as your first sorting and sort descending and remove the Preferred from the sorting. See if this does the trick for you.





