-
SQL Tile Limitations?
Hey! I'm attempting to replace existing magicetl logic in one sql tile. :) I'm having issues though. I want to replicate this very easy grouping then inner join. Does the SQL tile support this grouping ability?
-
Lock Cards by default when created
Dear all, When a new card is created please lock it by default instead of keeping it unlocked. Thank you. Best Regards, Tejal
-
DomoStats Datasets Field Suggestion
We wanted to leverage a DomoStats for Datasets, particularly the field 'Description', to provide context to the data that exists in our instance so we can leverage AI. Our hope was to use this dataset, get it AI Ready with our definitions/context, and be able to ask an Agent questions like "which dataset should I use for…
-
Make the Flex Table the GOAT chart
I feel like the Flex Table has the potential to be the Domo GOAT chart, but it's so locked down, I end up never being able to use it. Here are my suggestions to unlock its potential: Allow for multiple series, so you can group at more than one level. i.e.: first two columns are Region, State Allow to set a manual vertical…
-
Recursive calculation in domo etl
Hello Team, In my dataset i have a task to calculate the forecast value when the revenue is null for the current month. The forecast can be calculated by the formula which is Previous month revenue + previous month revenue * variance. However when the previous month revenue is null then I want the forecast value to be the…
-
sum based on distinct in another column
hello, this seems to be straight forward, but I could not get it. I wanted to sum up the cost based on distinct code, but my beast mode does nto work: a sample data, I wanted to calculate sum of cost by distinct code, the sum should be 33. each code has the same cost. this is my beast mode: SUM( CASE WHEN(distinct `code')…
-
Dynamic Variables should dynamically change formatting as well
Our company loves the beta of variables. We are able to create charts now where our users are able to change the dimensions and metrics they want on the fly. Our only problem is that we aren't able to dynamically change the format of that metric. So if our stakeholders select Business Area and they want to see the total…
-
Federated Connection not displaying the latest run under the datasets
We would like to show the last run for federated connection should show the most recent database refresh time. Currently this date only gets updated on the initial connection or when the schema changes occurred
-
Creating BeastMode to Identify Freemail Users Using LARGE list of Freemail Domains
I'm trying to create a beast mode calculation that will identify users based on a domain field I have that identifies the domain from the users email in its own column (emaildomain). I have a list of hundreds of email domains that are freemail domains. I've tried to create a Case When statement for when the emaildomain is…
-
Point ETL Output to Existing Dataset
I want to be able to point the output of an ETL to a pre-existing dataset. If, as part of a fix or as part of development, I need to make alterations to the ETL to get a desired output that I don't want to be the final ETL, it would be great to be able to make the changes and then point the final ETL to the preexisting…
-
RecipientEmails in Send Email function
Hi, I am using SendEmail function for the first time. I have 2 columns in my Dataset - Email and Email2. I want to send emails to Ids present in both these columns of that row. I am struggling with the email format to be used in Recipient Email column- I tried the one below in snapshot and it didn't work. Kindly help.…
-
Standard quick filter formatting for variables
When viewing Quick Filters on a card, the visual design of a selected radio button is different for a variable than a data column or beast mode filter. I would like them to be the same format. I also would like the filter titles to have the same font format. Variable quick filter titles are a darker color than data column…
-
Support for having reusable ETL Logic
We are trying to redesign our existing ETLs (Magic ETL) whereby we want to have two identical sets of ETLs one for Full Load and another for incremental Load. Since the ETL is complex and there are number of ETLS that will adapt same pattern, we would like a functionality in Magic ETL where we can store entire Business…
-
Struggling writing data from Pro-code app to dataset (appending data)
Attached is part of my app project where I am writing out a row to my dataset upon submittion by the user. Goal is to track the submission for use in reporting and other automations. Row will be used in a workflow to fire off API requests and ultimately submit a Jira ticket for the user who submits this in a secure…
-
Manifest.json is not getting saved.
I converted a Brick to an App. The Brick was working fine and was able to store input data to an App DB collection. However, after the conversion, I'm no longer able to save any data—sync is disabled. I tried changing the collection and enabling sync in the Manifest GUI/JSON editor, but it doesn't save and throws an error…
-
User Submissions to Brick Not Saving to Collection
We've created a Brick that allows inline editing/writeback. It allows me to successfully submit new rows to the related collection but other users who have access to the Brick via the app are not able to successfully submit new rows to the collection. I've shared edit access on the collection itself and we also have PDP…
-
Creating a Running Percentage Chart
I want to create a Running Percentage Chart. The x-Axis is the date in my dataset, y-Axis goes from 0 to 100%. My raw data contains two categories. I would like to display the running percentage of the two categories side by side. The existing 'running total line' shows the absolute value of the metrics. Instead of the…
-
Magic ETL Flow Error:
Hello Community Team, I'm encountering another issue while trying to save a workflow—an error message appears during the save process (see attached screenshot). As shown, my dataset is configured within the same compute integration, so it's unclear why this error persists Regards, Ritesh
-
How to secure our form brick when embedding forms publicly
I have created several forms using the Form Brick/App. Some of these forms collect sensitive or personally identifiable information (PII) from users. Since these forms are publicly embedded to collect user information, how can I ensure they are properly secured?
-
No Data Message is not being shown in Flex Table Card.
I'm using a Flex Table in a DOMO card and have set a custom No Data Message in the card properties. However, the message doesn’t appear when the card has no data — the space is just left blank. Interestingly, when I switch the chart type to a regular Table or any other type, the No Data Message displays correctly. I've…
-
Not able to open Magic ETL
Hello Community members, I had a task of making use of DOMO ETL. First of all, is it really mandatory to have a cloud account to make use of Domo Magic ETL, or can we use it without it? According to my DOMO team, they have given me all the accesses. Whenever I am trying to navigate to Magic ETL, it gives me the below…
-
One Click Domo Scripting with Bookmarklets (Favelets)
Ever wish you could easily delete a Beast Mode from the Beast Mode Manager? Or click a button to delete all cards on a page before deleting the page? Well now you can with bookmarklets! If you aren't familiar with bookmarklets (sometimes called favelets), they are browser bookmarks that run JavaScript code when clicked. I…
-
Magic ETL - AI Forecasting
Hi everyone, I tried using the AI Forecasting for the first time and after grouping the data by month (same as the forecast freq) and removed some null dates, I was able to successfully run a preview, which was great. However, when I tried to save and run the dataflow, it kept on failing with an unknown reason. When I…
-
Same Variable Name on Different Datasets
Hello, I was wondering if there's a workaround to use the same variable name across different datasets? Right now it seems like variable names need to be unique and used across the instance. And so when we try to create some generic names, the variables would need to have different names. Is it possible for one set of…
-
Can we create a custom thank you message for forms in app studio?
I am using forms in app studio, currently when we submit a form, it does not acknowledge our submission. 'I would like to see a thank you for submission' message. How can I achieve this?
-
Workflow Issue - no matching field
I have a workflow that works in one instance and trying to recreate it in another instance. However, I can't seem to select the same option when working with the Get Object From List in the Domo List Utilities Package. In the original workflow, it looks like this: In the new one, I am not able to select the same value for…
-
1 customer assigned to 2 sales person, how to show the total correctly?
Customer Sales Rep Customer Current Points Balance Bob a 75 Bob b 25 Tina b 125 Jimmy a 65 Above is an example dataset. I have an APP that has 2 filter cards (Customer & Sales Rep) and a single value card showing 'Customer Current Points Balance'. So that when I select: Customer = Bob → then Customer Current Points Balance…
-
Flip Y Axis in Analyzer for Negative Numbers (i.e. "spikes in shrink")
• Customers who deal often with negative numbers (think merchandise loss prevention and spikes in 'shrink') need a way to represent negative numbers and their respective increases/decreases because of the potential for these negative numbers to become positive. • Currently, using bar charts doesn't allow a way for users to…
-
Dataflow Locked/Unlocked in DomoStats Datasets
Looking for a way to identify whether a Dataflow (ETL) is locked or unlocked using DomoStats. In the "Domo Governance - Dataflow Details" dataset, this information is readily available in the "Restricted"* column. However, we have been unable to locate a corresponding field within any of the DomoStats datasets.
-
SUM(DISTINCT) based on another column
Customer Sales Rep Sales Manager TOTAL Customer PTS Bob a Rudy 100 Bob b Rudy 100 Tina b Rudy 125 Jimmy a Rudy 65 I have a sample dataset above. As you can see, Customer Bob is assigned to 2 Sales Reps & the Total Customer PTS = 100 no matter which Sales Rep it is. Since I'm the manager Rudy, I want to see the Total…