ArborRose Coach

Sounds like you have a firewall issue. Azure SQL typically use .database.windows.net domain…something like that. And you need to make sure you have the IP addresses used by Domo includes in the Azure SQL firewall rules.

Orphaned datasets would be datasets that, when investigated in DomoStats, would not have "In Use in Cards" or "In Use in Dataflows". So you should be able to use DomoStats Connector to connect to DomoStats -Dataset Usage and filter for no references in cards or dataflows, especially with a long "last accessed" timestamp.…

I don't think there is a direct way to programmatically add a custom button inside a pivot card to trigger an export. But you can probably do something similar through a custom card or app.

Sounds great. Good job.

Domo datasets have a unique identifier behind them. When you view a dataset, you will see the identifier in the URL. When you make a copy of an ETL, you are normally setting up new datasets rather than pointing back at the original source of the tile. This pertains specifically to output tiles vs inputs. Output tiles…

I try to group filtering and sort of summarize based on the groups: Location: Dallas, New York Type: Retail And if no filtering is selected, display 'No filters selected'. Or you could try something on a single line such as : 🏢 Branch: Toronto | 📍 Province: Ontario | 🛒 Type: Retail

It sounds like the PDF export process is capturing the initial value rather than its current state. I assume it is because the displayed value isn’t persisting its selection. You could try making sure there's a persisting variable tied to the dropdown. Make sure the dropdown value is explicitly updated and reflected in the…

You can't directly change the connector type for an existing dataset. Behind the scenes I believe Domo has a unique identifier so it knows two different datasets, even if given the same name. You can update the connection settings for the existing connector. Or create a new dataset with a different connector. And migrate…

Great job. Glad to hear you found the answer. Five points to Gryffindor.

Thank you for the additional information. We need the ability to apply color rules to specific columns based on the values in a different column. Column-Specific Conditional Formatting Based on Another Column: Allow numeric or text columns to be color-coded based on the values of another column. For example: In a mega…

I am not sure I understand the request. Color rules are by column unless the box is checked to apply to row. You can make multiple columns react to the same formula. Can you elaborate?

I believe you can use the share button to give editor access for datasets, even if the user is a participant for everything else.

Publish app allows you to create a public-facing version of your dashboard that can be accessed by users outside your Domo environment. It is used for creating dashboards intended for an external audiences. When you add a domain as a subscriber, the published app is only accessible to users from that domain. This is a form…

Yes, you can. One way is to create an ETL that does the aggregate (total) and joins it back to the details. location value location1 100 location2 200 location3 300 result after joining location value group total location1 100 600 location2 200 600 location3 300 600 Create a bar chart (or another card) using the value as…

Use add beast mode to create a new calculation using a formula like ( `Paid Amount` + `Savings Amount` ) / `Bill Amount` Domo uses back ticks to enclose field names. Name it something like "Ratio". Save it and make sure it validates properly. Also make sure you have no null or zero values in Bill Amount. Otherwise you will…

I don't use the API with R-Domo. I use other connectors via Python, etc. Based on your "check list", it looks like you can communicate with a small dataset of five rows. That makes me lean toward thinking the size of the dataset may be an issue. You might try gradually upping that size and retest. I've had an issue in…

I don't know any way to impersonate a user to test PDP in Domo. In the past, I requested it as a feature but I've never seen any enhancement for it. I create fake users to test PDP policies as whatever group I need to test.

I concur with @ggenovese. Your month number zero is producing invalid values. DATE(CASE WHEN LENGTH(`Month Number`) = 1 THEN CASE WHEN `Month Number` BETWEEN '1' AND '9' THEN CONCAT(`Year`, '-0', `Month Number`, '-01') ELSE NULL END WHEN LENGTH(`Month Number`) = 2 THEN CASE WHEN `Month Number` BETWEEN '10' AND '12' THEN…

Yes, it seems possible. But it requires configuration. Keep Quadrant Identifier in the Series (Top-Level Chart): Make sure the "quadrant identifier" is used in the series field to maintain the color-coded legend for the quadrants in the scatter plot. Use Unique Name as the Drill Key: Set the drill path so that clicking a…

Some suggestions: • Check API Rate limits • Verify the query itself • Check API Authentication. Make sure the token has not expired. Test with a simple GET. • Check if there's too much data being fetched. Maybe try a small set as a test. • Check with IT to make sure no firewall settings changed, blocking the call

I would suggest logging into Quickbooks as admin. Make sure the user has full access to the company with no restrictions. Remove Domo Workbench. Restart QuickBooks and retrigger the authorization process again.

I think what you are asking is whether Domo has a way to integrate hurricane and earthquake information. If you look at recent discussions there was a recent conversation about this topic. You can link to an external API from places like NOAA to gather information about weather such as hurricanes and earthquakes.

If your fiscal year starts in February, you need some type of fiscal year definition, Fiscal Year. CASE WHEN MONTH >= 2 THEN YEAR ELSE YEAR - 1 END For a date calculation, you would have something like CONCAT(Year, '-', Month, '-01') To get the last day of the month, use: Add Days function: Add 1 month to the first day of…

Wow, there's some neat stuff going on in this post. We need @Eddie Small to get these three on a talkabout. (Sorry, I made up that word because it's late on a Friday and I can't remember what Eddie calls those neat online get-togethers.)

Opps….that code example is Python. As @MarkSnodgrass answered, you can find Jupyter Notebooks by going to Data and then follow the three dots. If you want a basic overview, post in questions and one of us will give you a few steps to follow. There are also ways to make JSON calls for weather that I have used to do…

There are various sites that offer current and historical weather data. But most of the historic data requires a paid plan. OpenWeatherMap: Endpoints for current weather: /weather Historic: /timemachine Parameters: lat, lon for location, dt for the specific timestamp (Unix format) Limit on requests per minute; historic…

I don't see any reason why you couldn't. You could use the Python tiles to create a custom model or leverage built-in libraries. Use Domo's social media connectors to pull comments or posts to Domo or call with API. Or consider using Domo's Jupyter Notebooks (Python). Something like this from vaderSentiment.vaderSentiment…

Very nice job David.

Thanks for sharing. I very much enjoyed seeing it. Nice, clean interface.

Workbench 2.0 (Web-Based Version) Pros: Accessibility: Accessible from any device with internet access, making it easier for teams to collaborate and support each other. No need to install or maintain local software. Centralized Management: Jobs and configurations are stored in Domo's cloud, reducing dependency on specific…