-
Issue with MagicETl Filter Tile
Hello there, I am trying to filter a dataset in MagicETL using the Filter Tile, and have confirmed that the data I wish to filter by exists in the dataset 'Cadence name' by 'Outbound - Short'. Yet everytime I try this by running a preview, I get the response "No rows matched your criteria".
-
What is the problem with my beastmode?
I am trying to make an outlier flag that flags values 50% above of 50% below the budgeted, or daily goal mount. I made two threshold calculations(dailygoal / 2) & (dailygoal * 1.5). I keep getting an error message, but I am not sure what I am doing wrong. Any suggestions? Thanks, and my sql command is attached below. CASE…
-
Using inline editor on an live sheet
Is there a way that I can use the inline editor on a live data set connected to google sheets? I'm trying to edit information that I'm getting from a google sheet, but every time the data set updates the inline edits I made are overridden. Is there a way I can work around this?
-
Error: "Shape input Alert (NUMBER) may not have been initialized, all inputs must be initialized"
What does this workflow error mean: "Shape input Alert (NUMBER) may not have been initialized, all inputs must be initialized prior to use?" I am trying to create a workflow that will automatically send a report to individuals when it is Business Day 5 of the current month. I created an alert that changes from 0 to 1 when…
-
What is the problem with my Summary Number? Need Help~
raw data: there are one month's data which shows on each day of the month on each storage location what kind of products are stored. Same day, same storage location may have several rows of data. I want the distinct count for the field '所在库位'（the Chinese means each storage location's name) to be shown as daily average…
-
Expose date filter's start & end date inside beast mode
The date range filter will always have a start and end date. I would like Domo to expose that start date/end date inside a calculated field as variables. My workaround is to have the same variable for fixed date ranges (MTD, YTD, etc) This would not be the case if Domo exposed the date filter variables inside Beast Mode…
-
Assign date range field on a per column basis
I have a single table that some columns or calculations use one date field and other columns use another date field. However domo only allows you to associate a single date field to the entire chart/table. This is extremely frustrating. For example the red columns use TransactionDate but the green columns use…
-
Domo NetSuite Connector Implementation
When configuring the NetSuite Connector, I receive an error. I validated that the NetSuite User Name and Password are correct, I also reverified that the Role, Script and Deploy ID's are all correct. I'm able to login to NetSuite as the user and run the saved search without any problems. Error Message: Domo is ready, but…
-
Avg Function
I am trying to find an avg over a 4 week period by using dimensions (text field.) Is this possible? I can get a count, but there isn't an option for avg.
-
Limit input/output rows
Hello, I am wondering if there is a way to set a limit on an object coming in from workbench or limiting it in DOMO itself to "error" out if the resulting dataset will contain more than 10mil or to not allow more than 5 mil rows to be processed. These are just examples, I would like to know if there is anything of this…
-
Dimensions and Measures
Hi, Is there a way to use a dimension field also as a measure? Similar to what you do in Excel while using a pivot table?
-
Add true card view reporting
With current DomoStats reporting we are missing the ability to track clicks on a card from a page. A Card will be reported as Viewed when the user clicks on the name of the card and actually opens it, but not if they expand the card (i.e., via Story Presentation Mode or via Story Presentation Mode via Next/Previous…
-
Add and Remove Dimensions via Control on Dashboard
As a Data Consumer, I want to have controls that allow me to add or remove dimensions on a card within the dashboard, So that I can tailor the data view to explore various perspectives or drill down into specifics. This flexibility helps me perform individual analysis or combine different dimensions to gain a comprehensive…
-
Control for Chart type Change on Dashboard/App
This would be similar to the already existing chart chooser that is available in the detail view of a card. Additionally allowing data consumers to pick and customize their view of the data at the app/dashboard level via controls that would be customized and placed by AppStudio designers. As a data consumer, I want to have…
-
Getting grammatical error/invalid error on domo query filters(where clause)
Hi, I am calling a query on my ddx brick using domo query functions. Now when i try to pass filters which actually are the where clauses in which my where conditons are defined as comma separated. all are with IN operand. but getting the following error: "DA0012: A filter was provided to filter the data but it contains a…
-
IN vs Not IN two different cards
Is there a way to create a filter in a dashboard includes only the selected value in a card and includes everything else but this filtered value in another card? for example, if I have 10 ids, one card should have the sales amount for the specific ID I'm filtering on and another card should have average sales of the 9…
-
Hidden Beast Mode Functions
Hello, I was wondering if anyone created a list of hidden beast mode functions like Partition By which is not shown in the function list, but it works when we actually use it.
-
What is the error in my beastmode?
I am trying to make an outlier flag that flags values 50% above of 50% below the budgeted, or daily goal mount. I made two threshold calculations(dailygoal / 2) & (dailygoal * 1.5). I keep getting an error message, but I am not sure what I am doing wrong. Any suggestions? Thanks, and my sql command is attached below. CASE…
-
Storage cost questions
Hello all, Just curious about something. When a dataset is created with lets just say 1 mil rows, but then later in the day it increases to 2 mil, and then finally before the day is done it is decreased back down to 1 mil, would I be charged on the 1mil or the 2mil? Does the calculation happen at a specific time of day and…
-
Percentage of values in a column
Hello, In the beast mode how should I get the percentage of column totals like below, 50 hours worked is the 12 percent of the total hours (410). I need to create a column like % Hours so that I can make further calculated fields based upon that. Provider Hours worked Total Tickets % Hours % Tickets John 50 20 0.12 0.10…
-
Domo Governance Datasets Connector - App Studio integration
This most likely is already on the roadmap, but would love for App Studio content to appear on the Domo Governance Datasets Connector.
-
SQL for calc fields that sum (data is flattened) are dynamic -- based on current year
Hi there: I need help creating these calculated fields (in Beast Model) where they change based on current year. I created this in EXCEL but am still learning SQL - any help would be much appreciated! calculated fields cy Sum `rtfs_amount` for each DISTINCT `Base Request ID`where `fsa_spending_year` is current year cy+1…
-
XLM data stream via URL
Any tips on utilizing an XML stream via URL? I can't seem to get any of the XML connectors to work.
-
Beast Mode Details
Beast Modes tend to be created to test an idea then abandoned. We have several cards with multiple Beast Modes that are not actually used on the card. We would like to see some level of Beast Mode tracking where we can identify those that have been created but are unused either on the card or embedded into another Beast…
-
Dataset Direct Impact Reporting
In Data under the Overview tab, there is a section called Direct Impact. This data is very useful when doing Dataset maintenance as it will give you an idea of how that data is used. We would like to see this data reported in Domostats | Datasets so it could easily be pulled into any reporting that might be highlighting…
-
Custom Date & Timestamp Formatting in Analyzer View of Cards
Hello Domo users! As a relative newcomer to this fantastic platform, I am thrilled to share my first discussion post with the greater Domo Community. I've been working with Domo for nearly a year at this point, and it has been a wonderful experience and I truly admire the insightful analytics and operational abilities this…
-
Search Bar
Add a Search Tool in App Studio so users can search for dashboards that they have access.
-
Pivot/unpivot help Magic ETL
I have a dataset which looks like this before i pivot it: But I would like for it to look like this. Please ignore the fact there are duplicates, for example 2 IHS rows, I can fix that in the etl. I just want to pivot it and I'm struggling on something which seems to be easy. Thank you
-
How can I have the data (text type) distinct counted in Analyzer?
I want distinct count for Y axis rather than count, How can I do it ? Thanks in advance.
-
How can I limit the data based on user?
Hi, I have two Executives who work for two difference regions (Asia, Europe). I have dashboards with all of the data. But I want to limit the data visibility for the executive based on the region. Person 1 should see only Asia data on that dashboard. Person 2 should see only Europe data on the same dashboard.