Discussions
-
Bug? Card Analyzer falsely excludes null records after updating dataset via Magic ETL
Hi everyone, I wanted to flag an issue I ran into recently to see if anyone else has experienced this or knows if it’s a known bug. I updated a Magic ETL flow and expected the new rows to populate in my existing cards, but they weren't showing up at all. Here is what I verified before trying to find a workaround: Dataset…
-
How can I set up a text box Variable that can search for a text string in a field?
Hi Domo Community, Like the title says, I'd like to set up a Variable to be used in a dashboard where users can input text and it will search for the text string in related reports and return the results. For example, I have a "Description" field for items. I'd like to search "6mm bolt" in the Variable/text box and have it…
-
Filter Views should filter on all cards with equal priority
Currently, when mapping datasets to Filter Views in the Dashboard Filter View, Domo consistently prioritizes the dataset of the first card on the dashboard. If a user attempts to filter for an attribute that does not exist in the first card’s dataset—even if it does exist in the second or third card’s dataset—the filter…
-
How can I get null/empty string fields to appear as zeros in my ETL?
Hi all, I am running into an issue where I am trying to convert null/empty string fields to zeros. I have tried multiple different methods with no luck. The fields continue to appear blank. I need zeros so I can use them in Beastmode calculations and conditional formatting. For context, this ETL is used to show quantity on…
-
Analyzer not showing the correct date when filtered
Hi Domo Community, I am running into a problem where analyzer is not filtering my table correctly. I will filter the Date field for 2025-05-15 but it will only display results for 2025-01-01 (all results are 2025-01-01). The date range is set to All Time and these dates fall within that range. There is no aggregation on…
-
Unable to export card in .CSV format
Hi all, I am facing an issue where I am unable to export a card in .CSV format. I am able to export it in Excel format just fine. I tested other cards and they were exporting correctly. It seems to only be cards powered by this dataset. Has anyone else faced this issue? Any insight into this issue would be appreciated…
-
Requesting ability to schedule on a quarterly, semi annual, annual basis
Currently I am only able to schedule reports on a monthly basis at the most. I have a couple reports that need to be scheduled on a quarterly basis (or more). Can we make that a feature?
-
How can I remove these multiples?
Hello, I have a Magic ETL that provides open order data based on an item number. One issue I am facing is if I have two or more types of open orders for an item, then they will cross multiply. For reference, I have 3 open internal requisitions and 3 open sales orders for 1 item. Instead of displaying 6 rows (3 IR and 3…
-
How can I create a beastmode that will return the desired substring in a field?
Hi all, I've given this multiple attempts and just can't seem to get it. I have a field called 'Destination' that I want to use in a Beastmode that will return the first substring of "B-FGI" or "FGI" in a value such as "Doe, John A-B-FGI-20.15.0003.B-FGI" or "Doe, John A-FGI-20.15.0003.B-FGI". I also want to create another…
-
How can I format my Alert so that it displays the information in vertical text?
Hi all, Currently my alert just has an attachment and link for the report. I have a customer who would like to be able to scroll and see all the order info. The first picture is what I'd like to have. The second photo is how it is currently configured. Thanks in advance!
-
How can I get rid of extra characters in attributes
Hi all, I have a field that lists carriers in an odd fashion such as below: 000001_BOSMAN_T_GND 000001_UPS2_A_F-EX 000001_UPS2_A_LTL I'd like to get rid of the unnecessary characters at the beginning and the end so it looks like this: BOSMAN UPS2 Is there a Beastmode function or calculation that can help me do that? Would…
-
How can I make a historical/week over week chart without a provided date field?
Hi all, I want to make a new but related chart that shows the trend of the SUM of total value week over week. The problem is that I do not have an available Date field in my dataset/ETL except for Item Creation Date which does not seem useful. Also, this total value field is a calculated Beast Mode: (safety stock qty*item…
-
How would I filter for Order Numbers that contain UN codes? While keeping all other part numbers
Hi all, I am trying to figure out how to do this in Analyzer via Beastmode or filter tool. I am trying to only filter/display Orders that contain a product with a UN battery code while still displaying all other items in that Order Number. I'm having a tough time finding a function that could do this. Any ideas? Thanks in…