ColemenWilson Coach

Being a data/viz guy of course I have an interactive map of everywhere we've been: I have a goal to see every National Park Site and 150 countries before I am 40. I am at 136 National Park Sites and 89 countries so far! @Ahmed I am headed to Australia in November! Any recommendations in the Southeast? @GrantSmith One of my…

If it is in the output dataset preview it should be in the output. I'd be happy to jump on a call with you and try and troubleshoot:

My first thought would be that the column is being removed in the Append Rows 1 step. You could switch it to "include all columns" if it isn't already and see if it comes through. EDIT: re-read your post and to clarify, you are saying that for the test 1 output `Month` is not in the output?

Unfortunately this is not currently possible. I would suggest searching to see if this idea is already in the ideas exchange and upvoting it or submitting the idea if it is not already in there.

This is already in the ideas exchange with quite a few upvotes, please add your upvote here:

You can do this using the radio button filter card: and then adding the filter card to your page. You may also want to hide the filter bar in the page filter settings.

I think a bit more information would be useful, as there are many ways to add additional rows to a table card in Domo without using ETL, such as: Remove a filter or filters Change the date range Choose different fields Add/remove aggregation Update the data source Change the data source Use a different data source type all…

CASE WHEN `DateValue` >= LAST_DAY(CURRENT_DATE()) + INTERVAL 1 DAY - INTERVAL 12 MONTH AND `DateValue` <= LAST_DAY(CURRENT_DATE()) - INTERVAL 9 MONTH THEN 'In' ELSE 'Out' END

You can double click on the beastmode within the beastmode editor to add it to the beastmode you are currently working on. Doing this just pastes in the beastmode code. In the future Domo will allow for a beastmode field to be used as a field the same way other fields are used in a beastmode. But currently this is not…

2 ways you could kind of group things together: You can modify the colors of lines connecting ETL tiles. You could group together tiles by giving them the same color line connectors between tiles. You can split an ETL into multiple ETL's and each ETL is a grouping. You can then connect the ETL "groups" together as inputs…

Yeah it is because the values are case sensitive. So in the beastmode it doesn't find a match for "Senior Managers" because the "M" is capitalized in the case statement but not in the data, so it places it in position 7 from the ELSE part of the statement. A great way to protect against this is to wrap the values in…

Rewrite it like this and ensure that there isn't aggregation on the sort, in the screenshot you have it set to COUNT. It should look like this: CASE WHEN `split_detail` = 'CEO' THEN 1 WHEN `split_detail` = 'Head of Business' THEN 2 WHEN `split_detail` = 'key management personnel(KMP)' THEN 3 WHEN `split_detail` = 'Other…

@MarkSnodgrass laid it out exactly how I did it. Keep in mind that your data can grow rapidly. For example, right now you have 400 rows, 400 x 400 = 160,000. Bumping that up to 500 takes your total rows to 250,000. So be cautious when using this type of self join.

Agreed with the above. If you want to do it in Magic ETL and just need to see any distances greater than 1 mile you could do this: Join all 400 rows to each of the 400 rows (note this would be 160,000 rows of data) Compare each location to each other location using the DISTANCE() function You'll need the coordinates of…

Instead of text boxes, you could use some other filter card. Then you could avoid using pfilters and reloading the page each time. I would recommend a slicer filter card for a similar look and feel to what you have currently. Filter Views are what most use for this type of situation:

It does not appear to be possible. I messed around with all of the settings and nothing is getting the slope value to round. If you'd like, you could submit this as an idea in the

Looks like this is a duplicate post. I have answered this in the other post on this topic.

Yes, this is possible using pfilters. Here is an article explaining pfilters:

You'll need to use the Domo Governance datasets for groups. The 'Users and Groups' report has all the fields you need!

It sounds like you already do, but just to double check, do you have this configured for your page:

I would suggest using the OneDrive for Business Connector. It is fairly straightforward to setup and you can control which sheet in the file you pull from:

We thought about campaigns, but are trying to find a free way to do this haha

This is currently not an option in Domo. I would suggest submitting this idea to the If it were me I would do what you've mentioned and create custom "OR" conditions in a beastmode and present those options as a quick filter.

Yes. Scheduled Reports have the option to attach a CSV file to the email.

Sure thing: Copy the embed code from the Microsoft Form 2. Download from the Domo Appstore: HTML Easy Brick 3. Edit the HTML Easy Brick, paste the embed code in the HTML section 4. Save and close 5. Use the OneDrive for business connector to pull the form results into Domo Keep in mind that all that is happening is that…

Hello, have you talked to your CSM about Form Builder? If form builder is not an option for you, we have used DDX bricks to embed 3rd party forms in Domo (Smartsheet, Microsoft forms, etc…)

This would be huge for us. We have tried to do as @swagner recommended but it is limited and time consuming.

What are you trying to accomplish with the OVER ( ORDER BY Review Date ) ? That is what is causing the duplicates.

You can filter out anything newer than 1 week old using the following: CASE WHEN `PowerSellerLockDate` < = CURRENT_DATE() - INTERVAL 1 WEEK THEN 'In' ELSE 'Out' END Then apply the beastmode as a filter in the card. If you want to filter the values in Magic ETL, use a filter tile and the following formula…