MarkSnodgrass Coach

One possible solution would be to leverage the fact that you can send a text message via e-mail. See this article here to know how to build the address for your cellular provider. https://www.digitaltrends.com/mobile/how-to-send-a-text-from-your-email-account/ You would also need to create a new user in Domo that has that…

You might try using the Transpose option in the General Chart Properties.

You could create a beast mode based on your date field by doing something like this: CASE WHEN MOD(MONTH(`date`),2) = 0 THEN CONCAT( DATE_FORMAT(DATE_SUB(`date`, interval 1 month),'%b'),'-',DATE_FORMAT(`date`,'%b')) ELSE CONCAT( DATE_FORMAT(`date`,'%b'),'-',DATE_FORMAT(DATE_ADD(`date`, interval 1 month),'%b')) END You…

This might be a limitation on the chart and you might need to submit an idea in the Ideas Exchange section of the Dojo. The only color options are in the Data Label Settings and none of them seem to change the way you need them to. You might need to consider a different background in the interim until they enhance the…

You could control this by creating a beast mode for your bar values where it checks to see if the date is beyond today and make it zero or blank if it is, otherwise use the value. Something like this: CASE WHEN `Date` < CURRENT_DATE() THEN `barvaluefield` ELSE '' END Hope this helps.

One option would be for you to select the select columns tile and the tile before and then choose the "copy to clipboard" option and pasted it into a text editor. It is JSON formatted data, so you could add in all your fields in your text editor and then paste it back into Magic ETL. Here is what the select columns tile…

your static dates need to have single quotes around them. You could also wrap the static dates and your date field each with a date function so that Domo properly evaluates them.

@ozarkram I would double check your formula because what I wrote doesn't have "isnull" in it, it has "ifnull".

Try this to deal with the additional scenarios DATE( CASE WHEN LEFT(`description`,5) = '*SLD ' THEN IFNULL(TRY_CAST(SPLIT_PART(`description`,' ',2) AS DATE),`orddate`) WHEN LEFT(`description`,4) = '*SLD' THEN IFNULL(TRY_CAST(SPLIT_PART(REPLACE(`description`,'*SLD',''),' ',1) AS DATE),`orddate`) ELSE `orddate` END)

@ozarkram if your data has no consistency or pattern as to where the date is going to be, then it is going to be extremely difficult to construct the correct statement to extract it. If you can identify all the possibilities, then you might have a chance.

Based on your sample data, this logic should work to extract the date from the description field when it starts with *SLD DATE(CASE WHEN LEFT(`description`,4) = '*SLD' THEN SPLIT_PART(`description`,' ',2) ELSE `orddate` END)

I would suggest moving away from the replace text and value mapper tiles and use the formula tile in your ETL. It is much more flexible and you can do all your work in a single tile. You can do something like this in the formula tile. CAST( CASE WHEN `field` = '#DIV/O' THEN 0 WHEN `field` = '--' THEN 0 ELSE `field` END as…

Which card type are you using? Are you able to include a screenshot?

Unfortunately, when a table is the scheduled report, Domo is essentially taking a picture of the table card and including it in the body. It is a fixed width and can't be adjusted. It would be a nice enhancement if the full table card was included, though.

It depends how you want to display the data, but at a basic level if you used a table card, drag in date of stay and market, then drag in market again and change the aggregation type to count. This would show you how many people stayed at each market on each day.

Agreed. There are a few like that. You are certainly not the first to be confused and wonder why certain properties aren't there. It's definitely worth spending a few minutes and seeing what charts are available in each of the chart type categories as they function differently even if they have the same name.

You still don't have the correct chart type selected. On the far right, under chart types click on the dropdown list that currently says "period over period" and choose "popular charts". You will then see a new list of charts. Choose Line Bar. Once you have that selected, drag a field to the y-axis and choose an…

Ahh... you just need to change your chart type to Line Bar. Under Chart Types, choose Popular Charts and choose Line Bar.

Understanding comparison options After selecting a period-over-period chart type in Analyzer and applying the desired columns to the x- and y-axes, you must specify 1) the time period you want to compare, and 2) the periods the selected time period is being compared to. You do this in the date filter menu, which is located…

It is a best practice to use groups when providing access to pages, so that it is not a tedious process to give access to additional pages to the same people. I would suggest creating groups and adding those pages to the appropriate groups. A short-term workaround might be to do the following: Go to the Admin Center and…

From a syntax perspective, you are missing an END statement. You only have one, but you need two because you have two CASE statements.

You can have your value field be a beast mode, which could be a calculation that would get your percentage. You might need to play around with a few calculations to see what is the correct combination, but it would be something like: COUNT(responses) / COUNT(location) You can then format the value field as percentage.

I would suggest adding a segment to show your total line. You can click on Add Dynamic Segment, select A, B, C. etc.., and assign a color for the line. Then drag the field into the segment field, which will become available after a segment is created. You can read the KB article about segments here:…

@lawiti you could add the date fields to your join criteria and then you could look for the nulls. You could also just join on the ID column and then use a filter tile after that and filter to where TableA date does not equal TableB date.

If you are only looking at the first character in a string you can use the LEFT function, like this: CASE WHEN LEFT(`orderstatus`,1) = '*' THEN 1 ELSE 0 END

If the * is always right next to SLD or SOLD then you could just tweak the beast mode to be like this: (CASE when `orderstatus` like '%*SLD%' THEN 'Sold' when `orderstatus` like '%*SOLD%' THEN 'Sold' ELSE 'Stock' END) If it can be anywhere in the string but also needs to contain SLD or SOLD then you could do this: (CASE…

You can use a case statement to evaluate this and look for SLD and SOLD. It would look like this: (CASE when `orderstatus` like '%SLD%' THEN 'Sold' when `orderstatus` like '%SOLD%' THEN 'Sold' ELSE 'Stock' END)

Column names are case-sensitive when Domo evaluates if a column is the same or not. For example, ID is different than id for Domo. You can use the Select Columns tile in Magic ETL to rename columns and keep your cards from breaking. Hope this helps.

Unfortunately, there are no sorting options for quick filters. It treats everything as strings and shows them in descending order. You would need to have the year first followed by the week number to avoid having all of the week ones grouped together, but you will still be stuck with it being in ascending order. Quick…