-
Is there a Workflow Function that allows user attributes to be updated?
I tried to customize the createUser function from the Domo Users package to be able to capture certain required fields we use when setting up new users but the fields would not update the user profiles. Is there a function available to do this? Goal is to create a Workflow Form on our Admin App that would allow us to enter…
-
How can I only show the top 3 in the bar graph?
Hi, I made this bar graph ( For example, number of people who likes flavor of ice cream) and I only want to show the top 3 flavors. How can I filter that? Thank you.
-
Filter Month based on Last working Day
Today is Monday March 3rd. I am using the following Beast Mode (shared previously in the forums) to filter to current month: Case WHEN DAY(CURRENT_DATE()) = 1 AND DATE_FORMAT(`Event Date`,'%m-%Y') = DATE_FORMAT(CURRENT_DATE()-1,'%m-%Y') THEN '00-Current Month' WHEN DAY(CURRENT_DATE()) != 1 AND DATE_FORMAT(`Event…
-
Cloud Amplifier - Snowflake - Choose schema and custom DB and Schema names
For Cloud Amplifier on Snowflake, it would be helpful if we were able to: Choose both the destination DB and Schema that the data lands in (rather than having to go only to the Domo managed DB and Domo manage schema "RAW_DOMO". Be able to rename the DB and Schema that is generated when the connection is set up The reason…
-
Cloud Amplifier grants
Hi, Cloud Amplifier requires Manage Cloud accounts. We’d like to request the enhancement to split this grant into 2: Create cloud accounts Manage All Cloud Accounts So, we could assign more granular grants to our end users who could create the Cloud Accounts but not manage all of them. Does it make sense? Thank you,…
-
Connecting to Dataverse
Has anyone connected to a table in Microsoft's Dataverse? If so, how did you connect to the data?
-
Filter Line without Column Turning Blank
Hi All, I'm using a calculation with a variable (see below) to select designed time periods and need to remove my revenue line (Hierarchy = Revenue) however, when I add filter "Hierarchy Not In 'REVENUE'" the column using the below formula returns BLANK for every row in that column but does not cause any of the other…
-
Apply a % Model based on an identifying field
Hi All I've got a challenge when trying to apply a sum(max()) value to my card as there is a variable I can't identify correctly In my data (anonymized) I have the following columns I need to use for this: [Customer], [Model Type], [Model %], [Master Description], [Sub Description] What I need to do is, when a [Customer]…
-
Variable & Control showing in a chart
In an App, to use a variable, you need to add a control → basically a filter card in an App or expand the card and see the control on the right side of the chart. However, it'll be easier if the control variable is showing in a specific chart like this, this way I don't need a separate card for to pick the variable control…
-
Hi I had a question about creating a view by joining two tables in the data tab of a card.
I am trying to join two tables to create a view in a DOMO card but I am running into a weird issue. Table 1 has 42.3 million rows and table 2 has 158K rows. When I do a left outer join to table 1 I am getting 297 million rows of data. Why am I getting more data than the two tables themselves it should be less data, not…
-
MTD & MTD Last Year Beastmode that calculate the ratio
so I have a beast mode that calculates the ratio of committed orders % committed count = SUM(CASE WHEN % complete > 0 THEN 1 ELSE 0 END) / COUNT(Order #) but I want to create a Beast Mode to calculate the same ratio but just for this MTD, so I tried this, but it return 0 CASE WHEN YEAR(CURDATE()) = YEAR(MONTH_END_DATE) AND…
-
Bulk-add IP Addresses to Whitelist
Hi team, We have customer who wants to bulk-add IP addresses to the "IP Address Allowlist" section in Admin > Network Security. However, the UI is limited to the following formats when adding IPs: -Single IP addresses -Range of sequential IP addresses -Mask range of sequential IP addresses Since they have a long list of IP…
-
"Send Now" Dashboard Feature - please add Card Descriptions
I love Send Now, it's a great way to get a whole dashboard into someone's hands without creating a PDF or PPT (and worrying about line breaks, etc.) However - it looks like CARD DESCRIPTIONS do not appear in the Send Now picture. I hope that's a small enhancement and easy to do - please consider. Those descriptions can be…
-
DomoStats Datasets report - Add Cloud Provider
Hi team, Our DomoStats Datasets report doesn't currently include a field which shows the cloud platform a dataset is stored on (e.g. Domo, Snowflake, Redshift). Same with the Domo Governance Datasets connector. Raising this here because a customer is looking for this functionality, and I do think it would be a useful…
-
Save Filter View for Dashboards & App Studio Pages with Selected DataSet
For dashboards and app studio pages that consist of cards across multiple datasets, the page filters are automatically set to the first dataset in an alphabetically sorted list. However, there are often situations where 1 dataset may not contain all the values as another dataset for a column intended to be filtered on. The…
-
pivot tile?
hi I am working in Magic ETL and am having a tough time knowing how to do what I am trying to do. Below I have a dataset with 3 columns shown that I need. What I need to be able to do is keep the msp last run date on the left hand side but then pivot the `delinquent payment 2` into column names then show the loan count So…
-
Revert Sort Icons Update in Card Analyzer
Anyone else hate the new sort icons in analyzer? When Domo updated their icons last month across the platform, they deployed these new sorting icons in analyzer: To me, these icons make no sense. First, ascending means larger data as you go down, so the icon having smaller lines as it goes down is opposite, and vice versa…
-
You've been Domo'ed (and other notifications) do not indicate which instance the email came from
There has been a kerfluffle at the community site b/c this key information was missing, additionally i work in a 90+ domo instance environment (a lot of publish) and users frequently lament not knowing which instance the "this dataset has been shared with you" email is coming from.
-
Add Median to the General Chart Properties
You can use the General Chart Properties to calculate the Default, Sum, Average, etc of your value. This is useful when using a beast mode that is using datediff or something similar, as using the Aggregation of the value iteself doesn't work with the date filters. Therefore, it would be nice to have the Median calculation…
-
Enable "to date" Time (eg. Month to Date compared to prior Month) Comparisons through yesterday
I use the time period comparisons feature often. I can compare this month Month to Date compared to last month Month to date. If today is December 10, then I have data for this month for December 1 - December 9. DOMO's native Month to Date feature allows me to compare to November. But the comparison includes November 1 -…
-
Dashboards Filter API Behavior Discrepancy with App Studio (Removing filters)
I'm encountering an issue with the domo.filterContainer() API in Domo App Studio. When I apply filters (Custom filter brick) using this API within my app, they work as expected. However, when I clear the filters using the UI (e.g., by clicking a "Clear All" button or removing individual filter selections), the filters are…
-
Bullet chart color rule
I have a bullet chart showing Sales, COGS, GM and it's corresponding Budget Amount As you can see, Sales and Cogs are over the budget, and I want to show the bar color to green. Whereas GM is lower than the Budget, I want to show the GM bar to be grey. How do I achieve this with color rules?
-
HTML Beast Mode help
Is there a way to add a colored line below a number value on a card? or even a "line break" colored line? I am trying to use beast mode/html to create a blue line to add below the SUM value of the card. I am currently using a single value card with: 'CONCAT( SUM(Actual_Count), ' <hr style="border: 3px solid #30B0E0; width:…
-
Can I use Python libraries in Domo?
Hey everyone, I’d like to use scipy.optimize in Domo to perform optimization calculations (similar to Excel Solver). Since MagicETL has a Python Tile, is this where I should implement it? Thank you!
-
Specific Role Permission for Custom Charts
We whitelabel Domo into our company's software to provide a limited Domo experience for our customers. I would LOVE to be able to allow our customers to upload their own custom charts and maps, but currently that requires them to have the Manage All Cards permission. I do not want to give that permission for a host of…
-
Domo Sandbox Commit & Promote does not capture Default Filters
It would be ideal for content committed and promoted via Sandbox to retain and deploy default filters
-
Workbench job that I created on 2/25 & set to append one day back, scheduled job ran multiple times
I built a workbench job on 2/25 & set it on a schedule to append with the logic at the bottom (appending one day in the past at a time). Even though I had it scheduled for once daily, for some reason the job the job ran twice as a "scheduled update". Any idea why this might happen, and is there any documentation of…
-
Move an existing page as as sub-page under another existing page (instead of recreating a new one)
I am looking for ways to move some of the pages that are not being used under a folder to mark them as archived. Is there a way I can do this in UI?
-
Equivalent to Excel Solver in Domo MagicETL?
Hi everyone, I'm working on a hotel lodging analysis and need to find something in Domo MagicETL with comparable capabilities to Excel’s Solver function. In Excel, we’ve used Solver to optimize the number of daily hotel room blocks (reservations made in advance) to minimize last-minute (adhoc) room bookings, reducing extra…
-
Bullet chart
I am trying to show the target in the bullet chart by region As you can see the data is populated correctly but for some reason that I couldn't figure out the chart value with the target is super high so I can not see the actual data in the chart