ArborRose Coach

Hmm… • Make sure all parentheses are properly closed and all function names are correctly spelled. • Make sure the data fields you're referencing exist in your dataset and are named correctly. • Make sure Current Week Index is a valid reference. • Division by Zero: Make sure denominators are not zero, as division by zero…

@MayaU_01 - I think you should look at my response to another recent question. I showed the way I like to do what I refer to as trends. Comparing year to previous year and the year before that. I use the same calculation formula to compare previous quarters across multiple years. Using this calculation, add another line…

I'm a little unclear what you are referring to. When creating or editing a dashboard in Domo, there are specific settings related to filter visibility. Dashboard creators have the ability to control whether filters are displayed to end users or not. This setting can be toggled on or off based on the preferences and…

Consider using coalesce for months with no value. Coalesce lets us get a value such as zero, when the condition is null.

I'm about to be configuring the same thing. A few things you might try… Check your IAM role for permissions. Since you are trying to load files with ".json", set the file name field to "*.json". Make sure files are truly formatted JSON. Make sure your files are not being overwritten or deleted.

I do year to year, month to month comparisons using formulas. The results can then be easily added to a bar chart or table chart. Or a bar chart with the numbers below. Each day the numbers move based on the data. Today March is empty. When the end of day numbers come through, March will start to appear. Filters that are…

I'm suspicious of any code that isn't my own. But there's a site that can help with the Base64 conversion if you can't make it happen in your own code. The following may be useful… To get the client id and secret for your instance go to developer.domo.com. Steps for getting the Client ID and Secret Click on the question…

I hope I'm not including any of my private values in this. {cringe} The comment box reacts to the # symbols and such. So I will paste images. This code will download a file using the dataset's id set in the variable dataset_id. Id is found in the URL when you open a dataset in your browser. This code uses a Base64 version…

I don't have code to do a merge. But I can show you code for pulling down a domo dataset. And another for sending email. Generically its supposed to be something like this for pulling down a dataset. import requests Set up authenticationclient_id = 'your_client_id' client_secret = 'your_client_secret' base_url =…

I don't believe Domo has a direct API or method specifically for accessing its email notifications. I have sent emails using pydomo. I downloaded the information from a dataset to do a mail merge with my body. But as you are trying to avoid, it had to use my own smtp server.

If you are bringing the data in via API, you may have options to change the data type in the API settings. I use the NoCode oAuth connector, which has a schema definition. If the auto-detect does not recognize the data type you need, you can set it.

I concur with MarkSnodgrass. It is supposed to indicate an error, which you should see if you look under history.

I would consider truncating long responses to a shorten text with (…) at the end. You can then put a tooltip or hover functionality that lets someone see more text when hovering. Or…create a drilldown. Instead of showing the full text, set a drilldown to see more details. Excel should be a better export solution, instead…

I think it depends upon the type of brick. My page with blank bricks allows me to add more cards with their own datasets, but I can't add more datasets to each card. However, the DDX Form and Dataset brick seems to have an icon to add datasets.

Perhaps there's another way to approach the problem. Can you provide a few sample rows of test values and a description of what you need?

I had this same thing happen to me last week. It turned out I miss typed single quotes rather than a back tick. I would have suspected order of operation but your parenthesis look right to me. Remove the space after the second occurrence of sum. Check column names for spelling and back tick quotes. If your first worked, I…

Good job DataMaven. Congratulations and thank you.

SEC_TO_TIME should be converting duration in seconds to a time format. It looks like the value is for the average session duration displayed with K, indicating thousands. As in average session duration of 170.85 seconds. The "0" indicates no change from the average in the current month to the same month last year. Your…

Hmm….sorry my workload is heavy today. As DataMaven mentioned…I'm not sure what I'm looking at with your fields in x and y. As for the %…there might be an issue in how your calculate the percentage of the total. You can try to calculate the % of a column total separately for each plan and combine them. Something like this…

Eat an elephant one bite at a time. Based on your description, it sounds like you are trying to create a dataset of all possibilities….every combination. I would try some kind of user interaction. For example, create a dashboard where users select their starting location from a dropdown filter. Then, based on their…

Try this: (1 / ((spend / revenue) / (sum(spend) / sum(revenue)))) * (2 / MAX(bid_multiplier))

I think the approach you mention is going to give to many records. You could try creating a separate table with unique combinations of routes with start and end points. Then create a filter with logic based on the last selection made. There's a searchable filter app in Domo but I've never used it.

Your numerator appears to be totaling the billable orders by country. Over the total of attempted transactions and voucher transactions by country. The use of "FIXED" seems redundant. What happens if you simply to something like SUM(BILLABLE_ORDERS)/SUM(ATTEMPTED_TXNS + VOUCHER_TXNS)?

A few possibilities… • You may need to use the WHERE clause to select only customers with rank less then equal to 10. • Make sure your data doesn't have any issues or missing values that could cause an error. • Verify your sum(NET_SALES_CY) aggregation is functioning as expected.

And something that has driven me nuts….color and borders. Add the following to CSS. table { border-collapse: collapse; width: 100%; } th, td { border: 1px solid black; padding: 8px; text-align: left; } th { background-color: #4CABC5; color: white; font-weight: bold; } td:nth-child(3) { border-left: 3px solid black;…

Expanding on my answer above…the following will retrieve the whole dataset.

Go to the AppStore on the ribbon bar and search for Blank Brick or DDX Blank Brick. Pick a new dashboard or one you setup as a test. If you are appending, select your dashboard from the list. It will open with a new card. On that card it wants you to enter javascript in the first window, your html in the next, and your…

CONCAT(DIVIDE(`YourColumn`, 1000000000), ' BN')

Hours: DATEDIFF(timestamp2, timestamp1) * 24 Minutes: DATEDIFF(timestamp2, timestamp1) * 24 * 60 Seconds: DATEDIFF(timestamp2, timestamp1) * 24 * 60 * 60

Change the values from % to decimal. For example, instead of 21%, use the value .21 so Domo sees it as a measurement. Create a card and choose the "Line Chart" option. For the X-axis (categories), you'll want to select the Row Labels (good, bad, evil). For the Y-axis (values), you'll want to select each of the Plan columns…