MarkSnodgrass Coach

@DataSquirrel you are going to want to look into recursive dataflows. Here are few KB articles to start with depending on how you would like to implement it: Implement with Magic ETL 2.0 (will likely run the fastest) Implement with SQL Implement with Magic ETL 1.0 You can also find a lot of chatter about it in the Dojo by…

That is interesting that there isn't an option to do that. I would suggest submitting this in the Ideas Exchange in the Dojo to have them add this in the future. One workaround would be to use the Summary Number area to explain what the colors represent. You can write a Beast Mode that will allow you to select as a field…

If they are both beastmodes, can you just copy and paste the formulas in the other beast mode? Also, if you have Magic ETL 2.0, there is a Formula tile and you could put your beast mode calculation in there instead.

I would suggest creating a Magic ETL and then using the Select Columns tile to swap the field names. Just make sure you rename exactly, including uppercase and lowercase. You can then easily switch all cards powered by a dataset over to another by going to that dataset in the data center and then click on cards and select…

I would suggest creating a Magic ETL and then using the Select Columns tile to swap the field names. Just make sure you rename exactly, including uppercase and lowercase. You can then easily switch all cards powered by a dataset over to another by going to that dataset in the data center and then click on cards and select…

I would suggest creating a Magic ETL and then using the Select Columns tile to swap the field names. Just make sure you rename exactly, including uppercase and lowercase. You can then easily switch all cards powered by a dataset over to another by going to that dataset in the data center and then click on cards and select…

I would suggest creating a Magic ETL and then using the Select Columns tile to swap the field names. Just make sure you rename exactly, including uppercase and lowercase. You can then easily switch all cards powered by a dataset over to another by going to that dataset in the data center and then click on cards and select…

@psmith it turned out to be not too difficult to create samples for you in both versions of Magic ETL. Here is what they look like Version 1 In the 1st string operations tile, extract the seconds by choosing Right 2. Extract the minutes by choosing right 5. (You're initially grabbing more than the minutes, but we will take…

@psmith are you using the new Magic ETL 2.0? If so, the solution will be simpler. If not, you can still accomplish this, but will require a few more steps. Let me know so I can provide the proper solution.

Have you tried the Hubspot Connector or the Hubspot Quickstart in the Domo Appstore? Click on Appstore at the top of the page when you are in Domo and then search for Hubspot. There are also some more advanced connection options if those two don't meet your needs.

@ndasa it sounds like what you are wanting to do is to create regions of the world map. You can do this with Domo using the Custom Charts feature. I would suggest looking at this: and this:

Agree with @GrantSmith . I would also add in an ELSE statement into the test logic and the final logic to ensure that it is evaluating the NULLS correctly. You could have blanks instead of nulls which would cause this statement to not return the results you are expecting. If you are actually have blanks you could do…

You might try forcing a convert to the date data type to make sure MySQL is properly reading them as dates.

@user094816 you can do this very easily in the ETL. See example in the image below. Start with your dataset and then add a Group by tile and do a count of your column you want counted. Add a join tile and connect it to your original dataset and your group by tile. Join on the appropriate key. This will keep all your rows…

Thanks @GrantSmith ! That did the trick. Here is a visual of what it ended up looking like for anyone else who needs to do the same thing.

I extracted the SVG markup from this page http://bl.ocks.org/simzou/6459889 and created a new SVG file. I don't think it is perfect because Domo is picking up 206 regions from it, but you should definitely get you pretty close. Here is the new one. (Note to Domo: Please support SVG as a valid file attachment in the Dojo so…

I found this online. It appears to have all the shapes, but they will likely require some re-labeling. You can do this with Inkscape or any code editor.

You likely can't accept an answer because it was created as a topic instead of a question. I did the same thing earlier because the orange button was initially default to create a topic. @Anna Yardley Can you assist and get this post changed to a question so the person can mark one of these comments as an answer?

@Ashleigh Great idea! Removing the format and changing it to default helped, but didn't quite get it there. See above.

@Ashleigh if you are referring to the y-axis, I am choosing format as number. are you formatting somewhere else?

I think there are a lot of possible answers to this, but here a few key things to consider: Know your audience - Are you building a card for an analyst that wants to see a lot of detail? Or are you building this for an executive that may just want to see a positive or negative single number? This will help you decide which…

According to this KB article, participant level users should be able to use the plug-in. Use the Domo PowerPoint plugin to pull Domo cards into a PowerPoint presentation. This plugin provides much more power and flexibility than the other available methods for showing cards in PowerPoint. Notes: The Domo PowerPoint plugin…

I'm using Magic ETL 2.0 and have not seen this happen. Make sure you are not relying on preview to determine if your join is working properly or not. You'll need to run the full dataflow to make sure.

I think you can avoid a lot of this using some of the built-in card functionality in Domo. First, have you tried using the Calendar card? It is great for this type of request as it turns a calendar into a heat map and would quickly show you the highest days of the week.…

Here's link describing the floor and ceiling functions. https://www.mathsisfun.com/sets/function-floor-ceiling.html

Actually FLOOR would replace ROUND and it would be outside the average function. Like this: FLOOR(AVG(DAYOFWEEK(`date`)))

Yes, I thought about including floor or ceiling in my reply, but wasn't sure which way you would want to go. I would do some testing and just see what works best for your situation.

Average doesn't work for words, but you could use the DAYOFWEEK function to get the numerical day, average that and then convert that to the day name. Would look something like this: CASE ROUND(AVG(DAYOFWEEK(`date`)),0) WHEN 1 THEN 'Sunday'WHEN 2 THEN 'Monday'WHEN 3 THEN 'Tuesday'WHEN 4 THEN 'Wednesday'WHEN 5 THEN…

Converting your page to a Dashboard Page will ensure that everyone has the same layout of cards. You can do this by clicking on the wrench in the top right corner of the page and select Design Dashboard.

When you create a beast mode, you have the option to click the checkbox "Share Calculation on Dataset" which is just above the Save button. This will allow you to have one beast mode but be available on any other card that uses that dataset.