MarkSnodgrass Coach

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.

Perhaps if you divided that by the day of the month, like this: SUM(COUNT(TicketNbr)) OVER (PARTITION BY board_name ORDER BY date_entered) / DAYOFMONTH(date_entered)

Have you tried using a window function to get a running total? It would look something like this: SUM(SUM(`ticket_number`)) OVER (PARTITION BY board_name ORDER BY `date_entered`)

Are you getting an error? Or just the wrong number? It looks like you are totaling 13 numbers (current week plus last 12) and then dividing by 12. Depending on what you are wanting to do, I would either drop the current week, or the last week. This post has good documentation on this if you haven't already looked at it.

Ah that makes some sense if you are using the x Periods Ago rather than the Last 2 Values.

A couple things to try. Add ReportDate into the Optional Group By. Also, try changing Data from Last and X Periods Ago to Last 2 Values.