Recent Discussions

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…

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…

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,…

Has anyone connected to a table in Microsoft's Dataverse? If so, how did you connect to the data?

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…

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]…

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…

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…

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…

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…

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…

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…

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…

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.

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…

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 -…

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…

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?

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:…

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!

It would be ideal for content committed and promoted via Sandbox to retain and deploy default filters

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…

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?

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…

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

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.

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.

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?

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…

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?