Best Of
Re: Mimic Vlookup in Dataset?
@deona720 Joins are the ETL equivalent of vlookup, with a few minor differences. You can read more about joins in this Knowledge Base article. In this case I would recommend creating a branch of your dataflow that filters your input dataset on Log Status = Leave so that you have one row per Member ID that includes the Termination Reason. Then use a left join with the original input on the left and the filtered data on the right, using Member ID as your join field. Drop the Termination Reason from the left table and the Log Status from the right table to mimic the output from your example.
Re: Can we have a personalized view of Dashboard and how can we arrange the dashboard for all users
Yes filtered views is the way to create the default filtered views with the flexibility to add additional filters if needed. This is a great article that explains filter views:
You can arrange dashboard/sub-dashboard order for all users in the company managed dashboards section of the dashboard pane: More > Admin > Company Settings > Company Dashboards.
Dashboards included in company dashboards will be seen listed first in the navigation pane in the same order set.
Dashboards not included in company dashboards will not be listed in a specific order and can be re-arranged by each user to fit their preference.
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: BETWEEN Beastmode function not working
I think the "BETWEEN" function is meant for the formula tile in MagicETL. That's why it probably shows up as a auto completion in the analyzer.
I agree that Domo should clean up the auto completion and show only functions that work in Analyzer beast modes.
b_rad
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.
Re: Supress Zero Value rows in Pivot table
You can filter out any value from being included in the pivot table that has a zero value like this:
