MarkSnodgrass Coach

All ETLs have settings that allow you different ways to control when you want your ETL to run. When editing the ETL, you can click on the icon that is just to the right of the zoom controls (it looks like 3 lines with dots on them). I would suggest having it run whenever either dataset is updated. This will ensure you…

You would need to combine the data in Magic ETL so that it is one dataset. You would have two input datasets: order detail and sales goals. I would use a formula tile on your order detail to get the first day of the week for each order. You can use the following formula to do this (replace dt with your actual order date…

You could look into utilizing some of the Domostats tables to at least alert you which cards are tied to a dataset that just lost its certification. Would take some work. I agree that it would be a nice feature to be able to toggle if you want things downstream to be automatically de-certified.

In the Workbench job, under Configure and Additional Settings, you can change the When To Terminate Long Running Jobs to 1 hour. This should trigger a failure notification for you. Also, under Transforms, you can add a Calculated Field and add a timestamp column with the NOW() function. You can then create a card that…

Try this, though you'll need to re-type the index and variable fieldnames if they don't paste in correctly. SUM(CASE WHEN index >= date AND index <= DATE(CONCAT('12/31/',YEAR(CURRENT_DATE()))) THEN variable END)

an easy way to get the last day of the year is to do this: DATE(CONCAT('12/31/',YEAR(CURRENT_DATE()))) You can put this in place of your 2nd date piece.

Unfortunately, the smart text doesn't support this yet. If there isn't already a submission in the ideas exchange, I would suggest adding one for this.

I would review this KB article on Workbench partitions and see if that works for you. https://domo-support.domo.com/s/article/360062446514?language=en_US

If you are using Domo Workbench to push your data to Domo, you can use Partitions to just send the new data. Magic ETL also has partitions. You could also use the append option your dataset so that it would continue to add to your Domo dataset.

Variables are an easy way to swap out fields in a line chart. Here's the KB article with a video if you are unfamiliar with it.

#5 was well done

Domo changed their KB site, so that link no longer works as you found out. Here is an updated link where you can find the Domo Documentation. https://domo-support.domo.com/s/article/360043430113?language=en_US Scroll down to Create Page Analyzer Links.

Depending on how your data is structured, you can use the pivot table chart to do this. Put your date field in the columns section and then your Interest Earned, Net Book Balance and Accrued Interest in the values section and your account number in the rows section. You can use the date range filter and graph by to group…

One possibility is to convert your date to an integer using the UNIX_TIMESTAMP function and then use the AVG function and then convert that value back to a date using the FROM_UNIXTIME function. It would look like this: FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(datefield))) You might need to add a round function in there as well in…

@jaeW_at_Onyx would be the one best suited to help you on this.

Any update on this enhancement? Would really like to see this implemented.

It could actually be a temporary issue and it might work in a few hours. Could also be worth opening up a support ticket with Domo and see if they can provide more detail as why it is failing.

You should create two beast modes, one that will be used for displaying the month name in the pivot table and one for the sorting. Create a beast mode called MonthName that contains a formula like this: MONTHNAME(`Offer Accepted`) and drag this into your columns field. Create another beast mode called MonthNumber that…

I would recommend you look at the library that @jaeW_at_Onyx put together. He has built a library off a lot of the private Domo APIs https://pypi.org/project/domolibrary/

You would need to create the zero entry in an ETL. You could do this with a join tile so that every location has a row for each type of value you want to report on.

Here is a video that walks you through it in more detail.

One of the easiest ways to do this in Magic ETL is to click on your input dataset and click on the data handling section. You can then select what data type you want to change it to. Be sure to click on the wheel cog next to it and in the Bad Values drop down, select Null. This will instruct the ETL to convert the data to…

It looks like you are using the checkbox filter card. If you put something in the optional group by field, the message will go away. You can put the same field that you have in your values field and just choose an aggregation type of count. This should fix it for you.

You should be able to use the CONCAT to add a day on the end, such as 1 and then convert it to a date. Like this: DATE(CONCAT(datefield,'-01'))

You should be able to use the CONCAT to add a day on the end, such as 1 and then convert it to a date. Like this: DATE(CONCAT(datefield,'-01'))

You can also just click on the cog next to the cast data type in the Alter Columns tile and under Bad Values, choose Null. The tile will then convert all the values to integer that are actually integers and then null out all the values that don't convert.

There isn't a straight listing of e-mail addresses for all of the dataset via e-mail connectors. However, in the data center, you can use the filter option and filter by type to dataset via e-mail. You can then click on each dataset and go to Settings and see what the e-mail address is.

In the first part of the tile, what did you choose for the "function to apply". I would suggest choosing Rank and then you should be able to use what you have selected for the second half, assuming PaidDate is a date. The next step would be to add filter tile after this and filter to where rank = 1, which would get you the…

In a line + grouped bar chart, the left axis is determined by what type of value is in the y-axis field and that becomes the line. The other items in the series become bars. To make the percent be on the right, you would need to have that be the bar, which would likely mean you would want two lines and one bar. You can…

Unfortunately, there is not a way to do that. A workaround would be to put a single underscore as the card title. Adding that functionality would be a good idea for the ideas exchange.