MarkSnodgrass Coach

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…

I'm not sure how that beast mode is showing as validated because your WHEN statement isn't valid. Do you want to process what is in your THEN statement when COUNT(DISTINCT 'orderID') is greater than 1? If so, then you would write it as such: WHEN COUNT(DISTINCT 'orderID') > 1 THEN .... Also, a count of the sum of line item…

@Shumilex I would point you to this post by @GrantSmith that should do the trick for you. You would add an extra calculation to divide the current week number from the previous week. https://dojo.domo.com/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages#latest

Make sure you are using the HTML table card. In your beast mode, you can use one CONCAT function and have as many links as you want. Example: CONCAT('<a href=https://www.google.com>Google</a>',' ','<a href=https://www.yahoo.com>Yahoo</a>')

I would suggest you use the Annotation feature to do this. Here's the KB article to learn more about it. https://domohelp.domo.com/hc/en-us/articles/360042923974-Adding-Chart-Annotations

Definitely seems like you followed all the correct steps. Either there is a bug, or the Filter Views feature is not completely built out to handle embedding properly. I would suggest sending this thread or these screenshots along with an explanation of your situation to support and see if they can confirm the bug/missing…

When you chose to embed the dashboard, which options did you select? According to this KB article, https://domohelp.domo.com/hc/en-us/articles/360043437993-Sharing-Cards-and-Dashboards-Outside-of-Domo-Using-Domo-Embed#h_01ESKWJ8QEVSRKQBQVQA9P65QP it indicates that the page filters will display if the Allow interactions and…

Have you created a filter view and saved it as the default? You should be able to set all of your criteria with the date range filter in the top right of the dashboard and then save it as the default. See this KB article for more information:…

@etszyingho if you can mark the answer as accepted, that will help others in the community. Great to see the massive improvement!

Awesome @etszyingho !!!

You may want to review this KB article regarding a recursive MySQL dataflow. You can avoid having to execute a delete statement, which is likely causing your timing issues. https://domohelp.domo.com/hc/en-us/articles/360043428133-Creating-a-Recursive-Snapshot-SQL-DataFlow

@Fadem if your join keys are two text columns, it is likely a data issue. Extra spaces and capitalization are two common reasons why rows don't match when you think they should. I would use the String Operations tile and trim spaces on both ends of your text. I would also convert the fields to upper case. Then try joining…

Glad to hear it @gospel . If you can mark any of the answers as accepted that you feel helped you, it will help out the rest of the community.

I plugged your beast modes into a card and replaced your fields with fields from my dataset and I got the correct numbers I would expect for my dataset. That tells me there is likely a data issue either with the filter dates or the premium amounts. I would also check for what field is used in your date range filter and if…

I would try and create a new redshift dataflow and copy in one step at a time and save and run it after each step to see if there is a particular step that causes the issue. This will help support out if you run into something and your syntax is something that the dataflow should be handling.

@RobB If I am understanding you correctly, for a given sku and a given date, you want the sales amount for that same sku 30 days prior, even if there is no record for that sku 30 days prior. You can do this as I described earlier and this is what it would look like in Magic ETL. I will try and describe it below. Use the…

You can use the Flex Table card to do this. You can adjust what is displayed in each column so that you don't see a bar or line graph, but the actual numbers. https://domohelp.domo.com/hc/en-us/articles/360043429073-Flex-Table

I would suggest using the Domo Dimensions calendar dataset to create a dataset that has all the dates for a given time period. You can then left join this to your sku dataset and replace nulls with zero. Then use your rank and window tile to go back x days. If you haven't used the Domo Dimensions connector, you can find it…

@GrantSmith I think "a little competitive" is understating things quite a bit. 😂 I do love the idea, though.