MarkSnodgrass Coach

Here is something to try in Magic ETL. If you have Magic ETL 2.0 it will run really fast for you. Here is a screenshot of generally what it would look like and then I will explain it below. Look at your data and determine what is the most columns that a row has, then add that many filter tiles minus one. In my example, I…

You can do this easily in Magic ETL. It would look something like this. Perform a group by of all trucks to get the totals. Join it back to your main dataset. You will then have that All Trucks total next to your individual truck total as another column.

I think you will want to look at this KB article and find the appropriate IP address to whitelist.

@user09644 is spot on. Additionally, adding the % before the word will allow you to look for that word anywhere in the phrase. If you only have the % at the end, then you are requiring that your phrase starts with the word retail. Using '%RETAIL%' will allow it to search for that word anywhere in the phrase.

You can do this with a story/dashboard page. When you are on a page, click on the wrench in the top right corner and then choose Design Dashboard. In the Dashboard Editor, drag Add Image into the content area. Select your image. Click on the pencil and choose Change Interaction. Select Link to Anything in Domo and select…

You might look into Dynamic Pivot and see if that would work for your needs.

I may not be understanding your data correctly, but couldn't you just do SUM(`Budget`) for your denominator rather than doing a case statement for the 4 regions? Like this: (CONCAT(ROUND((SUM(`ExpenseAmount`) / SUM(`Budget`)) *100,0),'% Usage')) 

Scott is correct, you can create a new SQL dataflow that does what you want. In your existing ETL, have the input dataset be whatever you called the SQL output dataset and then just connect it directly to the output dataset of your existing ETL. It would result in an extremely basic ETL that just has an input dataset and…

Ahh, I see that now in the sample data I mocked up. When I changed the beast mode from (`Lines on Time`) / (`Number of Lines`) to SUM(`Lines on Time`) / SUM(`Number of Lines`) then the average aggregation works properly. Give that a try and see how it works for you.

On your columns, set the aggregation to Sum for your Number of Lines and your Lines on Time columns. On the % on time, set that aggregation to Average. This should allow Domo to auto-calculate for you no matter how many weeks are selected and just show one company per row.

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