-
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.
-
redshift transform year_month
I am trying to do some transforms within a Redshift Data Flow where I need the year and month from a date field in the form of YYYYMM so I can do some math with it. I thought I could use the extract(year_month from date) function, but I get the following error: The database reported a syntax error. [Amazon](500310) Invalid…
-
Re: DOMO Dataset : Adding new column to the existing schema.
To add a column to an existing dataset, you would either need to add the column at the source of where it is coming from (i.e. via Workbench and SQL query) or create a dataflow with Magic ETL and add the new column there. If you haven't created a Magic ETL before, I suggest reading this KB…
-
App Store Statistics
It would be helpful if the App Store displayed some statistics that showed how many time it has been installed in all Domo instances, or how many times in the last year, etc.. This would help people know which connectors or apps are regularly used. It might also help people find connectors that they didn't know were…
-
Field list in Beast Mode Editor
When opening the beast mode editor, the fields listed in dataset fields are not in alphabetical order. However, the fields are in alphabetical order in the dimensions and measures section of the card analyzer. It would be great if the fields in the beast mode editor were in alphabetical order, so that they are consistent…
-
More control over line styles and symbols
It would be a helpful enhancement if you could specify the line style and symbol for each line in a line + bar chart. Right now, I can only use color rules to communicate some sort of relationship between other lines or bars. You currently have no ability to choose which type of symbol is use for each line and the line…
-
Data Center Filter Options Enhancement
When trying to use the filters option in the data center to find particular datasets or dataflows, after selecting an option such as type or tag, the popup only displays the top 10 options. I know you can start typing, but if you aren't sure of a name until you see it, it is difficult to find what you are looking for. It…
-
Bullet Card Hover Setting Enhancements
I find the bullet card type very useful to show targets vs actuals. However, the hover text properties don't align with the fields that are available so it doesn't allow you to show the target and actual values together when you hover over a row. Normally, I would add the field I want to add to the hover as a tooltip…
-
Calendar Card Enhancement
It would be a useful enhancement when you choose General -> Dates From -> Data that you could choose the most recent date, or the oldest date. Right now, when you choose Data it will start the calendar at the oldest date, which is typically not very useful. Choosing Current Date has the drawback that when a new month…
-
Hide Sorting Indicator Arrows when not hovering over them
It's great that you can sort charts different ways on the fly without having to go into Analyzer. However, once you click on the sorting arrows, they stay there and it can often get in the way of the visualization. It would be helpful if the sorting indicator arrows only showed up when you hovered over that area to change…
