MarkSnodgrass Coach

Here's a screenshot of a dynamic textbox card in a dashboard if this helps:

Interesting. I use the dynamic textbox card to display this type of information on a dashboard and it doesn't do the dotted underline. I don't have a notebook card in a dashboard to compare against at the moment, but you could try the dynamic textbox card as an alternative.

You shouldn't need to do any ETL or beast mode work for this. If using a table card, for example, drag in all 3 columns into your column listing. Click the pencil next to sales total and choose aggregation of Sum. In the date range filter, choose group by year. This should give you the sales totals for each client for each…

I don't see it in the appstore, and the KB articles lead me to believe it might need to be enabled by your CSM or support. I would start by asking your CSM to see if it needs to be enabled. If you are an admin, you can also go to Admin and Pages and make sure there are no pages listed as Business in a Box and it is just…

I have not seen that before. Are you sure that isn't a browser extension causing that? Is this on a specific card type? I would first try a different browser and see if it is still there.

There doesn't appear to be a connector for NCR. However, Domo provides a lot of different methods to ingest data. If NCR has an API, you could write your own custom connector. You could utilize the Dataset via e-mail connector if it can send data to an e-mail address. The CSV Advanced Connector and is useful for ingesting…

@jaeW_at_Onyx often recommends appending your data so that you have one larger dataset and allows you to easily perform drill paths. I would encourage you to look at the videos he has posted as there is likely one that covers this: https://www.youtube.com/c/OnyxReporting_2

@moneyshot that makes sense. Domo needs to add the divergent color chart properties to the standard table card and not limit it to the heat map card. That would get you what you need.

It's available on the Heat Map card and the Map card. You can find it under Chart Properties -> Diverging This KB article gives a breakdown on each property. https://domohelp.domo.com/hc/en-us/articles/360042924634

You are going to need to utilize some rank and window functions to determine if you have 3 or more consecutive dates. I would recommend using Magic ETL and the Rank & Window tile. You would use the Lag function to check for consecutive days for starters.

Agree with this and there have been other Idea Exchange posts with the same suggestion, but you can't vote them up anymore. See this similar one as an example: https://dojo.domo.com/discussion/21844/beast-mode-number-format-function Would be extremely helpful to be able to call a Format_Currency function for example to…

No problem. If you can mark my answer as accepted, that will help others in the community.

You are going to need to use Magic ETL and the Unpivot tile to make your dates rows. Then you will be able to make a line graph like that. This KB article will walk you through how to use the Unpivot tile. https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot

The issue is because your function is only going to return the week number variable when work date equals today. You can do this much simpler by using this as your beast mode: case when `Week Number` = WEEKOFYEAR(CURRENT_DATE()) then 'Current Week' else 'Not Current Week' end You could also choose to use your workdate…

@Hulachic5 I have limited experience with the Survey Monkey Connector, but I see that there is a Questions_Question_ID column that seems to coincide with the Pages_Question_Heading column. Have you tried using that column as your pivot column rather than the Pages_Question_Heading column since matching a numeric value will…

Which connector are using in Domo? If you are using the Microsoft SQL Server Connector, you are going to want to look at this KB article and make sure you have all of the prerequisites addressed, particularly whitelisting IP addresses and ensuring your company's firewall has the appropriate ports open.…

You can use the ABS() function to turn any negative number into a positive number. ABS Returns the absolute value for all values in a numeric column.In other words, any negative values become positive, and positive values stay the same. This is valuable when you want to see aggregation without considering positive and…

I would suggest using the calendar card. Then, if your data contains their actual birthday, to get their birthday into the current year, you could use this beast mode: ADDDATE(`birthdate`, interval (YEAR(CURRENT_DATE())-YEAR(`birthdate`)) year) Here's a link to the KB article for the calendar card.…

That's a good suggestion. I have added your idea to the Idea Exchange which you can vote up and get on the Domo roadmap. https://dojo.domo.com/discussion/53669/additional-options-for-multi-factor-authentication/p1?new=1 In the meantime, you could look at enabling SSO rather than use Domo's authentication system.…

Yes, SQL accepts mixed mode (Windows Authentication and SQL), which sounds like what you would want.

Interestingly, when I put this into my beast mode: TIMEDIFF('4:46:11 PM','4:54:28 PM') It resulted in a value of 23:51:43 rather than the negative approx. 8 minutes as you would expect. It seems as though Domo's implementation doesn't match MySQL's implementation, which is what it typically follows. I think if you took…

@Chris_Hippo if you haven't watched this walkthrough, you may want to and it may help you get close to what you are going for: https://www.domo.com/help-center/videos/watch/yXFS2uvD5Es/cat/PLc_JazWEwlVqiRoWcbD5My1Bw0_IpMX8z

Try adding ELSE 0 in your case statement like this: SUM((CASE WHEN (TIME_TO_SEC(timeDIFF(`Start Time (UTC)`, `Arrival Time (UTC)`)) / 60) <=10 THEN 1 ELSE 0 END)) / SUM((CASE WHEN `Case Number` is not null then 1 ELSE 0 end))

Agree with @jaeW_at_Onyx . I often use a heat map for this type of work. See below.

Agreed. If there were technical release notes that were available along with the general release notes, that would be very helpful.

I like to use the LENGTH and TRIM functions to test for this, which you can do in using the Add Formula tile in Magic ETL 2.0 or in a beast mode. It would look like this CASE WHEN LENGTH(TRIM(`Reserved By`)) >= 1 THEN 1 ELSE `Reserved By` END Hope this helps.

I would suggest you look at these two posts on creating these if you are wanting to display as table cards: https://dojo.domo.com/discussion/52681/domo-ideas-conference-beast-modes-running-totals#latest https://dojo.domo.com/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages#latest If you can display this…

If you don't have window functions in beast mode enabled, you will need to get that enabled by your CSM. Then, if you add the OVER() clause to your denominator, you will be able to get a count of your total number of subscriptions. Like this: sum(count(`subscription_id`) * `price`)/count(`subscription_id`) OVER()

@moneyshot you should try enabling the diverging colors option in the chart properties. It defaults to red to green and you can adjust additional settings beyond that.

There is not a concrete answer for this because what a person sees in their background is reflective of their screen resolution as well as how many cards that you have on the dashboard that require vertical scrolling. I would suggest at least 1400x700, but you may need to upload a couple different sample images that are…