MarkSnodgrass Coach

@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. 

Yes, you can do this by changing the interaction. 1. Edit your dashboard 2. Click the Edit Content button in the top-right corner of the cards that would be used to filter and select Change Interaction 3. On the right-side, click Apply to Selected Cards and choose the cards on your dashboard that should interact with the…

This video provides a nice walkthrough of building a nice story page: https://www.domo.com/help-center/videos/watch/yXFS2uvD5Es/cat/PLc_JazWEwlVqiRoWcbD5My1Bw0_IpMX8z More videos can be found here: https://www.domo.com/help-center/videos/label/dashboards-and-cards Domo created a couple real-life examples regarding COVID-19…

In order to do what you want to do in a Beast Mode, you will have to get a feature turned on by your CSM that isn't on by default. Ask them to turn on Window Functions for Beast Modes. Alternatively, you could accomplish this by using a pivot table card and put your Year field in the columns list. This would break up the…

The Pivot Table card has a chart property called Totals and you can select Show Total Rows as well as Show Total Columns.

Can you post an example of what is in that cell? Is it something like <a href=....>link name</a> ? You could write a beast mode to extract the portion in between the HMTL tags if that is what is in there, but I would need to see an example of what is there for sure. Also, are you using the HTML table card right now? That…

if you are using a table card, just go to the Chart Properties and select Show Total Row. Here is a link to the KB article that tells you all the things you can do. https://domohelp.domo.com/hc/en-us/articles/360043429573-Table-Chart

Domo's version of MySQL doesn't allow for the LAG function. However, you can use Magic ETL and use the Rank & Window tile to accomplish this. It will also likely run much, much faster if you have Magic ETL 2.0 in your instance. Here's a link to the KB…