-
Creating rolling averages in Magic ETL and de-emphasizing recent dates
At the most recent Domo Community Virtual Meetup, Michael Christensen demonstrated how to build out 90 day rolling averages using MySQL while also de-emphasizing the most recent dates in a multi-line chart. I was inspired the demonstration and wanted to create the same thing, but using Magic ETL. In this video, I walk you…
-
Understanding the Date Range Filter in Domo
The date range filter is a very powerful and useful feature in Domo. It allows you to view your data by day, month, quarter, or year and over different time periods. Understanding how it works, and how to get the most out of it, is very important when building your cards. Watch this video on how to use it and how to build…
-
Mark Snodgrass - NLC Mutual
Hi everyone! I'm Mark Snodgrass and I am the Director, Member Data Strategy for NLC Mutual. I have been in the IT and insurance industry for over 20 years and enjoy finding new ways to look at data and provide new insights for users. When I am not helping answer questions in the Domo Community or creating Domo videos on my…
-
Join with Between Clause in Magic ETL
I am working on converting some Redshift dataflows to Magic ETL 2.0 dataflows. I have a join statement in Redshift that looks like this: SELECT d."province_state" , c."Category" as SeverityRelativityCategory , n."Category" as SeverityRelativityCategoryMinusNY FROM "ihme_covid_19_population_death_shares" d JOIN…
-
Replacing single quote/apostrophe with nothing
I am trying to replace a single quote with nothing using the formula tile in Magic ETL, but it is giving me a syntax error. According to MySQL, you should be able to use a backslash as an escape character so that it will process correctly, but Domo is giving me an error. Any ideas?
-
Flex Table Number Formatting
I have a flex table where I am showing the first values and last values as columns. Domo wants to abbreviate some of the larger numbers, but I don't want it to do that. I can't seem to find a chart property that lets me control that. See screenshot. Does anyone know if this can be controlled? Or is this a feature request?
-
Get the number of weeks and days between two dates
I am needing to find the number of weeks and then the number of leftover days between two dates. I am open to doing this in our on-premise MS SQL, or in Magic ETL or in Redshift or MySQL, whichever is easiest. If I have dates of 8/1/2020 and 8/9/2020, for example, my expected result would be 1 week and 1 day. When I am…
-
Unable to select apply to selected cards in card interaction settings
I have built a dashboard with about 8 cards on it. I have a filter card that I just want to have it affect only 2 cards. However, when I go to Interaction Settings and try and change it to only apply to selected cards, the option is greyed out. See screenshot below. I have been able to do this before, so I'm unsure as to…
-
Dynamic textbox hide unless filtered
I have created a dashboard that has a US map with about 20 single values cards and dynamic textboxes surrounding it. The value cards all show the sum total when no state is selected, which is great. However, the dynamic textbox that shows the first state in the dataset when no state has been selected on the US map, which…
-
Cool Coronavirus Tracker
Domo put this out and is very cool use case of Domo Embed and Stories. Also has code to embed on your own website. https://www.domo.com/coronavirus-tracking
-
Story Dashboard Export to PDF
We have created a story dasbhoard with some filters applied. When we choose to Export to PDF, the filtering criteria is listed at the bottom as well as page numbering information. Is there a way to remove that? It really takes away from the look of the dashboard when that is showing. Here is a screenshot of the bottom of…
-
Adding Tags to posts in the Dojo
I was reading the Help & FAQ section in the Dojo and had a question about tagging. It says here https://dojo.domo.com/t5/help/faqpage/title/tagging that I can tag interesting posts or comments so that I can easily find them later and I would do so by doing the following: To add a tag: * Navigate to an interesting post or…
-
Card showing selected and not selected
Our marketing department is wanting to create a card that shows which coverages we offer and have it be one color if the customer selected is purchasing that coverage from us and another color if they don't purchase it from us. They currently have a manual process that results in something like this. They like the look,…
-
Google Analytics Most Visited Pages
I'm using the Google Analytics connector and I'm trying to pull the list of most visited pages by title, but I can't seem to find the right "Report" to choose when building the dataset. In Google Analytics itself, this data is under Behavior - All Pages. However, I've chosen the Behavior report when building the dataset…
-
dashboard summary number percentage issue
I am using the new dashboard/stories feature to design a page that would use the page/interaction filter. One one of the cards, I want to just show the summary number, which is a percentage. When the card is displaying the title, summary, and chart, the summary number properly shows the percentage. However, when I uncheck…
-
Human body SVG for Custom Chart
Does Domo have a human body svg to be added as a custom chart? We are trying to make a card that shows where injuries have occurred and it would be great if we could have a card that showed it a heat map on the body.