ArborRose Coach

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. https://www.base64encode.org 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…

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.

https://community-forums.domo.com/main/discussion/comment/90763#Comment_90763 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…

Responding to @DataMaven….trying to explain as best I can recall. Users need to pay close attention to data structures and accuracy. If I retrieve a date, I don't want it converted to a string or a datetime value. I want a date. And I want an accurate date. When we first configured Domo, we needed to pull from a third…

I agree with Grant. You should check on the error to find out why you're getting the error. An alternate method - you can automate the download of the file from the SFTP site and then upload the file into Domo using Workbench.

I'll have to read up on @timehat's suggestion. I don't use the Views Explorer because I don't want it altering my ability to use standard tools as the warning says. That message always keeps me from exploring…bad pun intended. Michelle is absolutely right about speed. Domo's implementation of SQL is horrendous. I too am…

While I have our instance set at UTC, I hate it. Domo treats API data as UTC. But the APIs I connect to are not UTC, they are in the proper US time zone. We worked tirelessly with Domo and couldn't get a solution working. Domo can't handle it unless we keep our domain set six hours ahead. That means I have to deal with…

Can you hold down the control key to open a card in a new tab? Unfortunately, if they made that a default…it would be the reverse for all us who do not want new windows opened.