MarkSnodgrass Coach

@lweiler doing some quick testing, it looks like you need to have something in the optional group by field in order for it to calculate the value change correctly. I would drag Company Name into the group by field. As an example, I created a test dataset that had one row with three fields (description, value, target) and…

Have you tried dragging one of your zip code fields or the actual fips code into the "select county fips code" field? It is expecting one of those values rather than the state name to properly populate. I would also suggest select the aggregation type to SUM for the field in the "select county value" field. Hope this helps.

Agree with @RobSomers that you should submit it to the Ideas Exchange as the gauge should have that feature. I have found the comparative gauge a bit too limited. I tend to use the multi-value gauge, which has a lot more customization options and can show the value or percent difference between two values.

Often when a field doesn't come in as the type I expected, I use Magic ETL to cast it to the appropriate type and then use the output dataset for my cards. There are a couple ways to do this in Magic ETL, on the input dataset, you can click on Configuration and then on Data Handling and then change the field to the type…

Domo's beast mode doesn't like the BETWEEN clause. Also, you are missing the THEN statement just before 'Large'. Try this: CASE WHEN `Variable Name`<= 1 THEN 'SMALL' WHEN `Variable Name` >= 1 AND `Variable Name` <= 1000 THEN 'MEDIUM' WHEN `Variable Name` > 1000 THEN 'LARGE' END

No, you should select Flag. Under my replies, you should see something like this: Click on Yes to accept it as an answer.

@Keisuke_n01 that's great to hear. If you can mark accept any answers that helped you, that will help others in the community.

You can create a beast mode that will look at the current date and then move it back to the last day of the previous week and then compare it against your date field. CASE WHEN `date` <= /* last day of the previous week */ DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL 1 WEEK) , INTERVAL (7- DAYOFWEEK(CURRENT_DATE())) DAY)…

If you want to prevent all lines and bar from showing future dates, you can create a similar beast mode and add it to your filters like this: CASE WHEN `Date` < CURRENT_DATE() THEN 'Historical' ELSE 'Future' END Drag this beast mode into your filters and filter to Historical. This will keep your chart from showing any…

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…