ArborRose Coach

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.

That post was quite a while ago. I don't know where a replacement page is or whether the functionality may have been obsoleted.

You can do a manual data export/import, exporting from eMoney in a supported format like CSV or Excel. Then use Domo file upload connectors or Workbench to schedule the import into Domo. Connect via API if eMoney provides an API. You can also use the Domo custom connectors to pull directly. As @ggenovese mentions, the…

Here are some troubleshooting steps to try: 1. Ensure Compatibility and Versions Excel and Domo Add-in Versions: Make sure both systems are running compatible versions of Excel and the Domo Excel Add-in. Sometimes version mismatches can lead to unexpected behavior. Domo Account Permissions: Verify that both users have the…

You lost me. There's a searchable filter app. There are bricks. But I'm not familiar with a "searchable" brick, nor how this relates to Coronavirus (the link you posted).

Can you configure a custom interaction using page parameters. Or use page level filters as a simpler approach. Using Page-Level Filter Navigation Use Domo’s Page-Level Filters or Dashboard Filter Views to set up a dropdown or search bar for order numbers. Set the interaction so that once the order number is selected, the…

You can create a Magic ETL using ranking and filtering tiles to separate the top 25, then aggregate the remaining records. Rank Travellers by Their Monthly Spend - Use the Rank and Window tile in the ETL. Use partition by for any grouping you need. Order by - choose your spend column and set the order to descending so the…