Best Of
Re: IFrame inside HTML DDX Brick
@muhammadtalha I believe the chart type you'll need is "badge_checkbox_selector", but it doesn't look like there's much documentation on it.
If you look at this page, it shows the basics around creating a Phoenix chart:
Re: Remove duplicate unknown comma separated values within a single 'cell'
Here's a screenshot with an example (it's using bogus data but illustrates what I'm talking about):
Re: Beast mode
In a beast mode you can do something like:
CASE WHEN `value` >= 1 THEN 1 ELSE `value` END
In a Magic ETL formula tile you can use the LEAST function:
LEAST(`value`, 1)
Re: Can you convert Date to Text in DOMO?
Is Domo interpreting your initial string as a date and the column is a timestamp data type?
There a function called STR_TO_DATE which will allow you to convert a string to a date type object based on the format string you pass in. Alternatively you can do TIMESTAMP() to convert your string to a timestamp since it's in the standard format.
Then you can use the DATE_FORMAT function on a date/timestamp field to return a string with the specific format you specify. You can read more on the format codes here:
Re: Concatenate in Magic ETL
You likely have some blank spaces in your 3rd party field. To handle these you can ignore empty fields:
GROUP_CONCAT(DISTINCT CASE WHEN TRIM(COALESCE(`3rd Party`, '')) <> '' THEN ` 3rd Party` END)
Re: Concatenate in Magic ETL
Use the group by tile, set Member Number as the Grouping field and then select Add Formula and use something like the following:
GROUP_CONCAT(DISTINCT
CASE WHEN ` 3rd Party` IS NOT NULL
THEN ` 3rd Party` END)
Re: "View As"
This is so needed. Especially for Admins. It gets difficult to sort through objects and validate that sharing/groups/PDP are all assigned properly. Having this feature would give admin the ability to visually inspect and check to make sure a given user sees only what they are supposed to see.
Re: How do I remove the "Warning: Not All the Data is Shown" from a filter?
@Moneyshot - In case of Donut chart I am unable to remove that warning even after applying the sort.


