Best Of
Re: Export Beast Mode from Beast Mode Manager
This is available through the Domo Governance datasets. If you haven't used this connector before, it has quite a bit of information about your instance. Go to your data center and then click on Connectors and search for Domo Governance. You can then choose Beast Modes as a report and it will add the dataset with the information you need.
Re: Release Notes - What Changed
@RobynLinden and I reached out to the Analyzer PM about this and he informed us an update should be coming soon.
Ashleigh
Re: How can I remove items from a mega table using a beast mode?
You'd likely need to utilize a window function and a case statement. Something like this might work for you
MAX(MAX(CASE WHEN `Country1` = `Concat Field` THEN 1 ELSE 0 END)) OVER (PARTITION BY `Part1`, `Country1`)
Then use this field in the filter to ignore values of 1.
Re: Merging Outlook Meeting & Sales Lead Data
I assume your cc emails are in one string and separated by a comma or semicolon. You are going to need to get them separated so that you have one e-mail address per row. You can do this with a method that I walk through in this video.
In the walkthrough, I am separating out strings of words into single words by looking for the space between words to build a word cloud. You would follow the same process, but look for what separates your e-mail addresses.
Hope this helps.
Re: Dynamic Chart Height
If there are a couple of tables in the dashboard and they have quite a lot of rows and you need to filter the data it becomes really complicated to navigate around the dashboard due to a lot of whitespaces.
How can I remove items from a mega table using a beast mode?
I have a table with 5 columns: The first column (A) lists parts, the second (B) lists countries, the 3rd (C) is a concatenation of the first 2 columns, and the 4th (D) is a concatenation of the same list of parts but other related countries. There are many more countries in column D than in column C, so most of the values in column C are duplicated multiple times. The values in column D do not duplicate. Column E indicates if there is a match between columns C & D.
How can I write a beast mode that will remove all the rows in the mega table for the matching country from column B? (In the picture, yellow highlights the matching row and the red indicates the rows that need to be deleted)
charles
Re: How can I remove items from a mega table using a beast mode?
how do you know which row you want to exclude?
