MarkSnodgrass Coach

There doesn't appear to be a way to choose your timezone. However, if you click on Advanced Schedule, It will show the time in the timezone your computer is set to next to the UTC time that you can edit.

The only spot to do that would be the description field which is just below the card title. You can notes in that field.

You are talking about datasets, so I am assuming you want to do this in a dataflow with Magic ETL. You can combine two datasets in Magic ETL with a Join tile. You would select Inner Join for the type of join and then select each of the fields that you want to use for your criteria. In your example, you would join on two…

The export should just mimicking what is in your actual data, so I suspect you have trailing spaces in your source data. You can easily fix this in Magic ETL or with a Beast Mode by using the TRIM function to eliminate any leading or trailing spaces.

@swagner Some sample data might help with troubleshooting what is going on here, but I also wonder if considering a different approach might be easier. Have you considered using Magic ETL to get the totals you need? You could use a Group By tile to group by salesperson and year, then use the Rank & Window Lag function to…

Are you familiar with drill paths in Domo? This will do what you are wanting to do and doesn't require any parameter passing as Domo takes care of that for you. You can watch this Domo video for a quick tutorial on it: https://www.domo.com/help-center/videos/watch/eB3jtaWAvAs You could also design your page as a dashboard…

That would be a nice feature if it did that. Unfortunately, you can only choose one interaction in the interaction filter. I would suggest submitting it in the Ideas Exchange section of the Dojo and see if it can be added to a future release.

@DataSquirrel there is a Domo user group Slack channel that I think you would enjoy being a part of. We also have weekly zoom meetings on various topics. @jaeW_at_Onyx can you get @DataSquirrel added to both?

@DataSquirrel I have not heard any talk of a pending upgrade of MySQL, but I would assume they would at some point. Domo is going to focus its resources on Magic ETL and Adrenaline Dataflows and will try and steer people to those offering as much as possible. It is cheaper for them if people use those more, and I would…

I don't think the CLI tool was intended to be used as a reporting tool. I believe it was created as a quick way to perform some bulk actions, such as permissions, groups, etc... Here's a link to the KB article.

Have you looked into the Domo Stats and Domo Governance datasets in the appstore? Many of these questions can be answered with these datasets and the Domo Stats quickstart will even build the cards for you that will answer these questions for you.

@Ashleigh You are missing the word interval DATE_ADD('DateCol', interval 12 day)

@jaeW_at_Onyx and @GrantSmith are the kings of window functions, so I am sure they can help you out. I would point you to these two resources: You can perform window functions in Magic ETL and they run very fast. Here is the KB article:…

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…