MarkSnodgrass Coach

If your postal codes are the same length and you want to add it after the 3rd character, you can do this: CONCAT(LEFT(postalcode,3),' ',RIGHT(postalcode,3))

Check the date range filter properties and see if you have anything set to compare against. Your date range can't be set to all time in period over period. Also, there is a question mark next to Compare To. If you hover over that, it will let you know what piece you are missing to make it work.

@GrantSmith is the GOAT of Regex. :) I imagine he will have something for you.

You shouldn't have to do a lot of concatenating. In the value property, set that to currency. In the general properties, choose Abbreviate Values. This should make your value show $496M.

You could try and use the unpivot tile and then potentially just join once. If you haven't looked into the dynamic unpivot and unpivot tiles, you could see if that would help you long-term. Here's the KB article. https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot

You would use multiple join tiles and just change the column that you want from your primary datasource to match your secondary datasource. Would look something like this:

@bp_paulo_fernandes have you looked at @GrantSmith 's post regarding running totals in beast mode? https://dojo.domo.com/discussion/52681/domo-ideas-conference-beast-modes-running-totals#latest He lays this out pretty nicely.

I would suggest using the Dynamic Textbox card to display this type of information as it doesn't put the underline in it. You can see this thread where someone asked the same question: https://dojo.domo.com/discussion/53732/summary-number-format-in-notebook-card Hope this helps.

Clicking the wrench and then the Edit Scheduled Reports just takes you to the scheduled reports management page. To schedule a dashboard, click on the up arrow with the box around that is just to the left of the wrench and then click on Schedule as Report

For you first statement, you can split out your data and perform a number of functions with tiles and then join it back together. Something like this: Your filter tile would filter to the invoice date that you want. The Group By tile would give you distinct list by just choosing customer as your column and then do some…

Unfortunately, this seems like a bug in the new release. It doesn't seem to support html, so you can't use <br> tags and you can't use \n like you can in other places. I would send an e-mail to support@domo.com and let them know.

Major kudos to @Anna Yardley @zcameron and Richard Carey for putting on a great awards ceremony! That was a lot of fun and a great way to interact others virtually. Thank you!

Ahh.... I see what you mean. I would submit this as a bug to Domo Support support@domo.com . Include that screenshot and information that it shows up on the export and hopefully they can include a fix in a future release.

Can you be more specific where this is showing for you or provide a screenshot? Is this on a standard page or a dashboard? Or is it when you are viewing an individual card as a single page? My PDP shield shows next to the card title, so I'm not sure where it would be showing in the bottom left.

Domo has a Slack Quickstart in the appstore that will not only create the connector, but build a page full of cards for you to help you quickly see what kind of visualizations you might make with the data. Search for Slack in the appstore and you should see Slack Quickstart. Hope this helps.

@loganherzog If you watch the network traffic in your browser when you view a card and click on share and choose Excel, you can see the API call that is being made and the necessary headers. You can call those same APIs within your application. You will just need to know the card id for each you want to export. Hope this…

The first thing to check is to make sure that the ETL sees your due date and payment date fields as dates. If they aren't you can fix that a couple different ways: on the input dataset, you can click on configuration and then expand data handling and set the data type as date. You can also wrap the DATE() function around…

If you are able to edit the Excel document and put some dummy data in that cell, that seems like the easiest solution. Another option would be to start at an earlier row and then filter out the header rows in the ETL by looking for certain information and then create your own column names with the select columns tile in…

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.