コメント
-
Even if I used the formula as you showed it, it should have worked. Are your fields numeric? Example above would give the same output I showed in my formula screenshot.
-
Using: Year,Season,VendorName,QtyMarketingForecast,DeliveredMarginDefine 2025,Spring,Vendor1,580,-68.23 2025,Spring,Vendor2,276,2548.93 2025,Summer,Vendor3,142,1050.75 2025,Fall,Vendor4,833,763.5 2025,Winter,Vendor5,902,-400
-
There's also an API for audit. I tried using Python to connect but received an unauthorized response from the API. I'm checking with our rep to see if it needs to be exposed for use.
-
I did not see it but I'm not very familiar with it. Which is why I asked it as a question. I saw a web reference that said it might be there, but may need to be requested. I'm assuming you need to automate something vs export it to a csv.
-
Yes, that's what I was thinking. Maybe its something Domo has to turn on for your instance?
-
Is it available in the Domo Governance Connector?
-
Sample data Item,Category,Cost Widget A,Electronics,1200 Widget B,Electronics,1450 Widget C,Furniture,980 Widget D,Furniture,860 Widget E,Office Supplies,430 Widget F,Office Supplies,390 Widget G,Tools,1500 Widget H,Tools,1330 Widget I,Tools,1420 When I do this as a bubble chart And then I expand it and filter it I do see…
-
I think that is the expected behavior - by design. What about adding a dynamic summary as it's own card? Create a separate card using the same dataset and filters. And it will change with the selections.
-
Great. Do they have a better explanation of what "fixed" means in the following? Bug Fixes Fixed how Workbench writes Database null values to Domo.
-
forecast_date run_date forecast_value 2025-07-15 2025-06-03 $45.00 2025-07-15 2025-05-27 $43.50 Month Category (which month) CASE WHEN MONTH(`forecast_date`) = MONTH(DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)) AND YEAR(`forecast_date`) = YEAR(DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH)) THEN 'Prior Month' WHEN…
-
lol…sorry about mixing the avg headcount in the months. Obviously, I was straight typing off sample data.
-
I think that depends upon whether you use aggregates in your columns. Month,Dept 1,Dept 2,Dept 3,Dept 4,Dept 5,Total November,132.0,251.0,59.0,477.0,70.0,989.0 December,127.0,250.0,57.0,366.0,68.0,868.0 January,123.0,235.0,53.0,391.0,68.0,870.0 February,128.0,233.0,58.0,311.0,69.0,799.0…
-
This is the only document URL I see for Workbench 5.2. And it's just an overview. I suggest you reach out to Domo support. I don't see anything in settings that would affect it. https://domo-support.domo.com/s/article/000005138?language=en_US
-
Some of the information you are looking for is probably in DomoStats: DataFlow History, Dataset History, or Scheduled Reports. But I don't think there's a DomoStats that logs workflow executions. Yes, you could have the workflow log its own execution status to a dataset…self-logging. Do an append row to dataset with a…
-
@Manasi_Panov - *** Awesome! ***
-
Using the examples I show, I manually count: January 1, 2023 → June 1, 2023 Includes both start and end date Result: 152 days July 1, 2023 → August 1, 2023 Includes both start and end Result: 32 days January 1, 2024 → February 15, 2024 2024 is a leap year Result: 46 days For a total of 230 days. To solve this I created a…
-
Depending upon your criteria, it may not be as simple as aggregating by group. Consider sample data like this: Member_ID Start_Date End_Date 101 2023-01-01 2023-03-31 101 2023-03-15 2023-06-01 101 2023-07-01 2023-08-01 Some memberships may not overlap. And in other scenarios, you can't group and count each membership and…
-
@ColemenWilson - is your screenshot showing a Snowflake dataset? Based on the icon, it looks the same as the question. Which would mean, it is not Snowflake..but something else.
-
I don't use Snowflake. So I can't test that. But in every dataset I tried, I get a the data handling options @ColemenWilson shows. And the icon he shows looks like your redacted dataset type.
-
Could you share a link to the video you watched? That might help clarify the context. The tabs you see can vary depending on the dataset's origin. For example, was the dataset created through a connector (like Google Sheets), or is it the output of another dataflow? This can affect whether the Data Handling section appears…
-
I concur with @ColemenWilson. The smart text is part of the visual layer in Domo, which doesn't export. Only the table data exports. The obvious work-around would be to include a calculated field in your dataset and include it in the card's data table. DATE_FORMAT(CURRENT_DATE(), '%Y-%m-%d')
-
There are several ways you can add buttons. You said - to a card, rather than a dashboard. You can put a button on an app and set the card in the app. But not on the card directly - except for putting a link or something in the card such as a link in a table. I don't think I've seen a way to put a link in smart text like…
-
The obvious way is to use AI. Review some of the recent forum AI Academy recording for examples. You could try something like stripping punctuation, [clean notes]: LOWER(REGEXP_REPLACE(`notes`, '[^a-zA-Z0-9 ]', '')) and then use a beast mode to scan for keywords CASE WHEN `clean_notes` LIKE '%widget pro%' THEN 'Widget Pro'…
-
This page link is all I can find. https://www.domo.com/blog/product-innovations-announced-at-the-connections-tour
-
@AndreaHenderson Thank you!
-
@brycec At the time, I wasn't paying close attention to when. But yes, the group by tile. I don't think the formula tile has given me any problems. I mocked-up the screenshot because my flow deals with patient fields. But even very simple formulas cause the error. I've started getting so used to it that I'm ignoring the…
-
I don't typically work with FIXED, so we're traveling outside my knowledge zone. It might help to post it as a new question with anonymized sample data in csv. I think what you want is something like a fixed revenue across year and month like this Fixed Revenue by Year-Month: FIXED (BY `Year`, `Month`) SUM( CASE WHEN…
-
The only thing I see any issue with is forcing the number under the name while they are both next to the image. Otherwise, it should be doable. If you can't get it working in an html card, do it as a brick. A brick is just html with css and javascript. Use the html example I gave you and put it into a brick. Then replace…
-
It's probably treating NULL and '' (empty string) differently. Even if you use NULLIF(id, '') , the value might get a leading separator. Thus flagged_ids still triggers the separator with a valid ID. ['', 'BE0000344532'] becomes ", BE0000344532" You could try skipping the nulls with a filter instead of relying on…
-
I've seen that when text fields look like numbers. Try something like this CASE WHEN LEFT(`Number`, 1) = '''' THEN SUBSTRING(`Number`, 2) ELSE `Number` END Just in case the following is useful to you. I just did a formula yesterday to deal with phone numbers like that. I strip the parenthesis, dash, plus sign, and the 1…