MarkSnodgrass Coach

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. https://youtu.be/QIuuXjiH1JY

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.

The issue is your date range filter is set to Yesterday. That means it will only return 1 day and likely 1 row if you have 1 row per day. If you want to compare yesterday to the day before yesterday, set your date range filter to Last 3 Days. Then sort by date descending. This will make the day before yesterday as the last…

I'm not sure if it is available in Beta yet or not, but I remember hearing about a SQL Editor for Views, which should address this issue for you. I would reach out to your CSM and see if they can provide any insight into that feature. They may be able to let you be a Beta user of the feature.

you can add a TRIM() function around the entire concat function and that will remove trailing spaces. You can also do it around each field, which may help.

Unfortunately, there is not a smart text field to display that information. It would be worth adding to the ideas exchange. I get around this by putting a dynamic textbox card above the other card and display the max date in the textbox card. Often using the dynamic textbox card as the card title for the card below it.

Yes, you will find it under the Vertical Bar Chart types

Not quite sure what your data looks like, but You can use this to get the prior month CASE WHEN LAST_DAY(datefield) = LAST_DAY(DATE_SUB(CURRENT_DATE(), INTERVAL 1 month)) THEN totalamount ELSE 0 END And this to get the 5 months prior CASE WHEN LAST_DAY(datefield) <= LAST_DAY(DATE_SUB(CURRENT_DATE(), INTERVAL 2 month)) AND…

You can also use this: /* my multi-line comments go here */

The remap nulls likely isn't working because the data contains blank spaces instead of actually being null. I would suggest dealing with this by creating a beast mode in Analyzer that looks like this: CASE WHEN LEN(TRIM(fieldname)) >= 1 THEN fieldname ELSE replacementvalue END This will trim out all the spaces and then…

Oh, that's true. If this is part of a dashboard, here is what I have typically done: I will stack a dynamic textbox card on top of my main card and use the dynamic textbox card features to display the date.

Drag that field into the filters section and select that value. It will be the only value. Then, go the smart text and choose filters and select that field. That should add it to the title.

Definitely worth adding an idea in the ideas exchange to allow for more options in display the last updated dated using the smart text option. Another option would be to use the formula tile in your ETL and create a field called last updated has this in the formula: NOW() that would store the timestamp of when the ETL ran.