-
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
-
Hi I am running into a weird issue with filtering on a card
I am trying to filter on only the null values for the fields Date Voided and Date Reconciled. The dataset I am using has data on the lines where these date fields are null. For some reason when I filter on either of the dates on the null value, it does not return any data. No other filters are set on this card.
-
Make a Copy of a Page within an App
There is an ability to create a copy of an entire app, but the ability to create a copy of just one page would be a nice feature as well.
-
Is there a way to search how many times a card was filtered?
I am looking at the activity log and I can see that it has following action: 'Created', 'Updated', 'Viewed'. But for filter cards I am trying to calculate how many times someone has applied filter on that card. Or even any filter on any card on a page. Are these metrics available in the activity log or any other DomoStats?
-
How to Filter for "Today AND Last 7 Days" in Domo Visualizer?
Hi everyone, I’m trying to implement a date range in Domo (using `Reservation Start Date`) that includes both Today AND the Last 7 Days at the same time. This will be for a weekly scheduled send. I know Domo has built-in filters for "Last 7 Days" and "Today," but I can't find a way to combine them in a single filter within…
-
Domo create react app not populating with the Domo specific scripts.
New to web development with Domo, I've ran domo login and that was successful, but when running npm create react-app todo-app @domoinc like it says in the documentation it just creates a basic version of react without any of the Domo specific scripts like upload. Is there something that I could be missing?
-
Hubspot Writeback error
Hello! I'm trying to set up my first dataset via the Hubspot Writeback and I'm running into the following error after adding the dataset ID. My dataset I'm using is a dataflow from magic ETL that is joining the Hubspot data (containing company ID, etc) with some other data in Domo. Any help to get past this is appreciated.…