MarkSnodgrass Coach

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…

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…