MarkSnodgrass Coach

Can you provide a few more sample campaign names? The word Expense is not in your first sample campaign name that you provided initially so I think I need to see a few more sample rows to make sure my suggestions will work for you.

If it is always after the the colon, you can use the SPLIT_PART function: SPLIT_PART(fieldname,':',2) If it is always a certain number of digits, you can use the RIGHT function: RIGHT(fieldname,7)

I believe you can have a more consolidated beast mode using the hour and concat functions and stacking the statements in the correct order CASE WHEN HOUR(startdate) < 6 THEN '12am-6am' WHEN HOUR(startdate) < 12 then CONCAT(HOUR(startdate),'am') WHEN HOUR(startdate) < 20 THEN CONCAT(HOUR(startdate)-12,'pm') ELSE…

You are going to need more than just the filter tile to do this. Here is bare minimum of what it would look like: Add a Constants Tile that you will use for the join tile Add a Group By Tile that gets the latest date Add a Join tile that joins on that JoinKey constant you created earlier so that the LatestDate field is now…

When using the over function, you need to use two aggregations. This should do it: MAX(MAX(date)) OVER()

If you have a known number of items to extract, using the SPLIT_PART function multiple times is the easiest way to go (i.e. SPLIT_PART(string,'-',1) for the first item, SPLIT_PART(string,'-',2) for the item before the 2nd dash, etc. If you have an unknown number of dashes, this method will allow you to handle it…

@ArborRose you can actually set the order of the output dataset without modifying the ETL and adding a select columns tile. In the Data Center, click on your dataset and then click on Data and then the Schema icon that is on the right. Hover over the left side of the page and you can click and drag any column to the order…

You could create a beast mode that multiples your number by -1 and then put that beast mode in your x-axis. The numbers will display as negative, but it would give you the look you are going for. You could also hide the scales so that the negative numbers don't appear on the x-axis, which might help with the look.

In the chart properties, go to the data label settings and click the + sign to add any of the available macros The text area respects when you hit the enter key to put items on separate lines. Also, in the General tab, choose Abbreviate Values to show items in billions or millions. You will also want to use the Format…

I would use a group by tile and put your object id in the first section and then in the aggregate section, do a count of object ids. This will tell you how many rows you have of each. You can then add a filter tile and filter to where your count equals one. You can then use a join tile to join it back to your original…

I would try mapping datasets 0, 1, and 2 to the same real dataset that you need so that you brick doesn't reference any example datasets in the code. I would think you would then be able to safely delete the example datasets. I'm not sure if there is a brick that only has one dataset, but if you find one, you might want to…

You can filter across pages by using pfilters (also called deep link filtering). I have a video on how to do this here: Here's a KB article about it as well.

In the Chart Properties section, you need to select Show subtotal rows under the subtotal rows section and then the subtotal section will be enabled for each column.

The easiest way I have found to do this is to use the Segments feature. https://domo-support.domo.com/s/article/4403089503383?language=en_US In the columns to create a segment, select the column that is in your series and then either select all the items in the selection, or choose match values and choose does not contain…

This video may help you:

For those dealing with bad data, here is a video that goes over various ways to clean it up:

TRY_CAST is only available in the Magic ETL formula tile. It won't work in the Analyzer calculated field. There are a handful of functions that only work in the ETL formula tile and this is one of them.

For those that are working on this challenge and want to use a Domo Brick instead of a Custom App, I walk through how to do it in this video:

In the ETL, you can use the formula tile and use TRY_CAST(myfield AS DATE). If it is a valid date, it will become a date value. If it isn't valid, it will become null. You can use this as a standalone formula and it will create a date field that will have dates and null values. Or you could use it as part of a CASE…

You are welcome @david_cunningham ! Keep up the great work on the answers!

Sounds like you are going to want your select columns json data to look like this: {"name":"A_Date"},{"name":"A_Invoice #"},{"name":"A_VV#"} One easy way to do this in a text editor would be to do a find and replace and replace "name":" with "name":"A_ This should prefix each of those columns with A_

I agree with @BryantCafferty that the confirmation e-mails were quite conflicting. Here is what mine looked like with two different dates (25th and 26th) and times (10am MT and 7am PDT) When I click on the Download ics so that I can add the event to my calendar it now says Thursday 4/25 at 10am MT. I think when I initially…

Use the wrench in the top right of the page and choose Edit Dashboard. Hover over the top right of the card and click on the down arrow and then select Appearance and uncheck Title. This will remove the title from the display.

Makes sense. You might try wrapping an IFNULL function around your entire running total function IFNULL( ,0)

Have you considered using the Chart Property "Fill empty data cells with 0"? It is under General in the Pivot Table card.

Yes. you should be able use the LIKE operator in the filter tile. I would add the LOWER or UPPER function to make it case insensitive. Adding the % sign around your string will make it a wildcard search. Like this: LOWER(statename) LIKE '%tex%'

I would take a look at the Upsert option in Workbench https://domo-support.domo.com/s/article/360043038714?language=en_US

I use the calendar because it is an easy way to have a built in incrementing list of numbers (1,2,3,etc.). You could just have an Excel file or a Webform that has a list of numbers, but I thought I would just use what is already available.

Way to go @JasonAltenburg ! Well deserved! You have been helping people for a long time and are always very insightful!

You could do this: CASE WHEN RIGHT(myfield,1) = '/' THEN myfield ELSE CONCAT(myfield,'/') END