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:
ellibot
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.
DomoDork
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.
Re: Bucket Ordering
@damen It looks like you are sorting on something other than your 'Pricing Buckets' which is causing the problem. You will need to sort on your pricing buckets for it to work. You will probably need to create another beast mode called something like 'Pricing Buckets Sort' which would be exactly like your 'Pricing Buckets' beast mode but instead of the bucket names would just be 1, 2, 3, etc. Then use that for your sort.
