MarkSnodgrass Coach

If the comma is consistent in your data, you can use the split_part function along with the left and trim functions to get this. It would look like this: TRIM(LEFT(SPLIT_PART(`addressfield`,',',2),3)) Hope this helps

@Ashleigh I believe this will work for you: /* check to see if today is Wednesday */ CASE WHEN DAYOFWEEK(CURRENT_DATE()) = 4 THEN /*its Wednesday, so just show the last 7 days */ CASE WHEN `date` >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 WEEK) AND `date` <= CURRENT_DATE() THEN 'Include' ELSE 'Exclude' END WHEN…

There aren't a lot of options to help with this. In the General properties, you can set the font size to smallest. Your other option is to incorporate it into the hover text settings so people could view the entire text when they hover over a value.

You have one too many ENDs in your syntax. Also, You also have one too many ELSE statements and your final ELSE doesn't have anything, which is likely causing an issue. Try this: case when `Union_Class` = 'A1' then case when `Class` IN ('A1','A2','A3','A4','A5','A6','EO','TB','TA','J','SF','F','SGF','GF') then 'Normal'…

To exclude holidays, if your company follows standard US holidays, you can add the Domo Dimensions Calendar dataset, filter to isHoliday = 1 and then left join your main table to this dataset and then filter out any entries where there is a match. If your company has a different set of holidays, you would need to upload…

It looks like you are wanting to pivot your data. In which case, I would recommend using the pivot tile in Magic ETL. It is built take multiple rows and turn them into columns and result in fewer rows. Here's the KB article: https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#2.

You could use the date range filter to show only last week. You could also create a beast mode that would tell you if the date is within the previous week. CASE WHEN `date` >= /* first day of the previous week */ DATE_SUB(DATE_SUB(CURRENT_DATE(), INTERVAL 1 WEEK) , INTERVAL (DAYOFWEEK(CURRENT_DATE()) - 1) DAY) AND `date`…

I would suggest adding your Brasil total as another column through the ETL. This way, you can always use it as the denominator no matter which item is selected. If you're not familiar, you can split out part of your data and then add it back. Yours would look different than this, but hopefully this gets you the concept.

I don't see that connector in my instance and I don't see anything in the knowledgebase. You can build your own connectors and deploy them to your company's app store. It's possible someone did that at your organization. If there is no publisher information on the connector, you could try reaching out to your CSM or Domo…

@NathanDorsch If you are only want to show the data for the rows that contain the last day of each month you could create a beast mode that would evaluate this for you: CASE WHEN datefield = LAST_DAY(datefield) THEN 'Last Day of the Month' ELSE 'Some other day' END You can then add this to the filtering section of the card…

Yes, you can use the rank & window and the lag function to get the previous value for each product and then use the formula tile to place it in your main column list. However, first you are going to need to get a complete list of dates. You could get a distinct list of dates from your existing dataset if you know that…

I had to set the Account_ID to floating decimal in the datasets configuration so the data type would match, but that was it.

I believe you need the Datasets from DomoStats and the Accounts dataset from DomoStats. You can then join the Datasets table to the Accounts table on AccountID.

It doesn't look like the DomoStats or Domo Governance datasets contain this information. I believe the comments option is a newer feature, so they may be available through one of these datasets in the future. I would start with asking your CSM about where that data is stored and see if they can arrange something for you.…

@user17774 Glad that worked for you. If you can accept any answers that helped you, that will help others in the community.

I would suggest adding another group by that aggregates by body part and then join it back to your initial group by. You can then use the formula tile to calculate the percentage. If you are unaware, you can have multiple lines go out from any tile so that you can perform different operations such as this and then join…

I have not heard of the Domo Advanced Builder before. My guess is that it is a premium product that costs money. It may also be deprecated as I don't see it in the Knowledgebase articles anywhere. I would suggest checking with your CSM to determine the status and availability of it. You may have come across this article in…

Have you tried using the first beast mode that I suggested that creates a new group name and then use the use the activity date field in the date range filter? The date range filter has a lot of great options like current month, last 30 days, etc... Seems like this is all you need.

What values does your 'Current_Date' field have in it? Based off your first screenshot, I thought you would be using 'Activity_Date'. Your beast mode would get you MTD since you are looking at the month and the year. If you need all rows with an activity date in the last 30 days, you might try: CASE WHEN…

@GrantSmith back to beating me by milliseconds again. 😁 You may be first, but what about better? Only @Golfoholic can answer that. 😉

You can create a new group name and then use this field in your visualization to do this. Your beast mode would look like this: CASE WHEN Description IN ('0_0-10_Period','0_11-30_Period') THEN '0-30' ELSE Description END You can then just drag in your value field and it will aggregate it based on what aggregation you…

Make sure when you are looking in the preview that you are looking for the new column you just created "Rent Last Changed". Don't look at dRentLastChanged as that will not be altered. Also, if your dRentLastChanged is a datetime or timestamp field, you could use a formula tile and just do this DATE(dRentLastChanged). This…

Unfortunately, that does not appear to be an option right now. You might try using one of the new DDX bricks apps where you will have more control of your table styling. If you search for DDX in the appstore, you will see the different options. You might try the DDX HTML Table app as a first option.

You can enter in the individual e-mail address into the scheduled reports, even if they aren't Domo users. Might not be a fun exercise if your list is a hundred people or so, but that would let the unsubscribe link function properly.

To "restart it", I would delete the schedule and create a new one and see if that works. To avoid future issues like this, I think you will need to create a Domo User Group and have all of the individual people in listed in there rather than using a company Google group. Domo can't tell that the e-mail address that you are…

I believe your issue is that you aren't actually using a date field in your x-axis, you are using an integer (even though it is the year of a date, I'm guessing). Try using the date that is being used in your date range filter as the x-axis and then set your date range filter to graph by year.

For your situation, I would recommend doing this in Magic ETL as it will be a lot easier to manage because you can break things down to into smaller chunks with multiple formulas. For example, I would created a formula called AdjustedStartDate that looks like this: /* check to see if the start hour is too early */ (CASE…

You might need to tweak this a little bit, but this is what I put together for someone else who had a similar question in the Dojo. /* check to see if the start hour is too late */ (CASE WHEN HOUR(`startdate`) >= 17 THEN ((UNIX_TIMESTAMP(`enddate`) - UNIX_TIMESTAMP( /*move it to the next day and start at 9 */…

Try adding a partition by if you want to be the percent of that business name sum(amount) / sum(sum(amount)) over (PARTITION BY `BusinessName`)

@mhouston assuming you have window functions in beast mode enabled in your instance, you should be able to use this to get the percent of total: sum(amount) / sum(sum(amount)) over ()