ArborRose Coach

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…

Hard for us to visualize what you are dealing with. @rco…is it possible the value he's looking at is a Bitwise operator? (Where each position in the value represents a bit value in binary. And each bit maybe corresponds to an impression?)

Assuming my direction is correct, you'll need to apply ABS() around your formula. Hard to say without all the details of the formula. You want to calculate the absolute value of the actual variance formula, not just the column, then sum it. ABS(Actual Value - Budget Value) If your data is grouped, you would need to sum up…

If I grasp the concept properly: In the context of digital marketing and advertising, an "impression" typically refers to the instance when an ad is displayed to a user. It's a measurement of how often an ad appears in front of someone, regardless of whether the person interacts with the ad or not. If you have an online…

Are you saying you can't just multiply by percentage based on the campaign? CASE WHEN Campaign = 'Campaign 1' AND League = 'NHL' THEN TotalImpressions * 0.40 WHEN Campaign = 'Campaign 1' AND League = 'NBA' THEN TotalImpressions * 0.40 WHEN Campaign = 'Campaign 1' AND League = 'NCAAF' THEN TotalImpressions * 0.20 ELSE 0 END

Sounds like the issue has to do with abs() being applied to the total sum instead of each individual variance value. Calculate Absolute Variance Row by Row: Use the abs() function on each individual value in the "Actual Variance" column to get the absolute values row-by-row. Sum the Absolute Values: Once you have the…

I don't think Domo has a built-in feature for automatically changing the chart type. You can simulate the behavior using filters, multiple cards, and structuring your dataset. You should be able to do something like this: Creating a Response Type column that categorizes each survey question. Use multiple cards (or multiple…

I think it also has a lot to do with interactivity. Apps have more capability with workflows, forms, etc. I agree with @Data_Devon. If dashboards work for you, use them. There's no need to work through apps if you are monitoring/analyzing metrics without more process needs.