ArborRose Coach

Sign in to your Google account and find security settings. It should be under manage your google account, security. Check third-party apps with account access or something like that. You should see a list of apps that have access.

Note for anyone reading this thread. I believe Grant's solution will also work. But I did not test it. As Mark mentioned, TRY_CAST does appear to be working in the ETL. And that's where I want it happening so my issue is solved. Thank you both @MarkSnodgrass , @GrantSmith .

Testing it on a calculated field in a card, it's rejecting TRY_CAST as a valid command.

If the source is from Google, you wouldn't be editing the google data, you would be editing the dataset in Domo that came from google. Any edits would be overwritten when the dataset is refreshed from Google Sheets. You could create a dataflow to isolate the inline edits. That way it would not be updated by Google's…

Typically, you would do it on a date field. But I believe it will convert a string value using YEAR(`fsa_spending_year`) You can use aggregate functions like COUNT and SUM inside beast mode calculations. Just wrap the whole case statement in SUM(…). It's okay to be new. I haven't been on here as long as the ancient ones.…

You don't need SQL. In beast mode, make a calculation such as… CY: CASE WHEN year(`fsa_spending_year`)=year(curdate()) THEN `rfs_amount` ELSE 0 END For previous year, subtract 365 days. Two years previous, 730 days. Etc. PY: CASE WHEN year(`fsa_spending_year`) = year(date_sub(curdate(), interval 365 day)) THEN rfs_amount…

Did you run them concurrently or one after the other finished? Based on the error it sounds like its saying you can't authenticate a second time while something is already running. Meaning, wait until its finished to then do the second…using the same account. And make sure that account isn't attempting to log in somewhere…

Domo also has JSON oAuth connectors for making generic connections to APIs. You can find them by entering JSON into the AppStore.

It sounds like you already have your token information configured. Next step would be to find the connector in Domo. Xero connectors for Domo are listed in the AppStore. You will see AppStore on the ribbon bar at the top of your Domo screen. Enter Xero into the search and hit enter. Several Xero connectors show up. Pick…

The syntax appears to be correct; all commas and parentheses seem to be used properly. There may be an issue with the usage of $fourteenDaysAgo in the $match stage. In MongoDB, you typically use variables defined within an aggregation pipeline stage using the $$ notation, but here it's used as a string value.

Welcome @david_cunningham

As David notes - you will need to aggregate ("group" and sum/count), with necessary fields. If you add fields to an output, the data will "break" or split on that data. Example, if your objective is to sum the amounts by store then you might include Store, Quarter, Month, and Sales. Since Month is in the set, it will split…

If you have a column such as a date in your table for goals, you can identify the quarter the same way you can pull month - QUARTER(mydate). Quarter being 1,2,3, or 4. When I configure my primary transaction flow, I have a column pre-calculated for each of year, quarter, month, and week. That way those values are readily…

You will need to make sure there's a connection between the data sources. Something in common you can use to join the sets. Your raw data would be showing something like a date and sales amount. Date, Sales 2024-01-01, 1200.00 2024-01-23, 900.00 2024-02-14, 2400.00 And your month goals might be something like Date, Goal…

You don't need to explicitely create indexes as you would in traditional databases. Domo's automatically optimizes for performance. Slow performance may be due to complexity of the dashboard or an issue in how you have things structured.

One way you could do it would be to append to a dataset using an ETL. Create a dataset and make sure it has a column to store the date. In the ETL dataflow, set a formula value with the current date and that in the date column within the dataset. Use the "append" tile to append data each day, the column value will act as a…

I have given this example in previous answers. Say you create a formula for the current year. You can use the same formula to also find the value for the year before {previous year}. To find the difference, just subtract one from the other. This should be the same thing you are working with. The difference being, you want…

You can Google "emoji" to find sites and catalogs. This one might help. https://emojidb.org/circle-color-emojis

Obviously I don't have your data or your structure. This was just using something mocked up. Dates would be actual dates and I would have a calculated field that would identify the week start date.

Calculation for 1/2/23: CASE WHEN Week Start Date='1/2/23' THEN Value END Calculation for Total: SUM(Value) Calculation for Average: AVG(Value)

OpenStreetMap (OSM): OpenStreetMap is a collaborative mapping project where users contribute geographic data. You can access OSM data through various tools and APIs, such as Overpass Turbo (). Use queries to extract zip code boundaries for Mexico City and export them in GeoJSON format. Natural Earth: Natural Earth provides…

Admin » Governance » Toolkit » Schema Management Schema Management lets you change the column type (data structure) of a dataset. If your dataset has an integer as the data type for a field, you can change it to a date.

There appears to be something in the ETL that isn't valid. Perhaps it doesn't have a output tile or something?

Colemen's answer converts the information to date. There is a toolkit function for Schema Management to modify structure for that date. Please mark Colemen's answer as yes if it solves your issue.

Manual recreation - identify the form's field from the existing Smartsheet. Create a Domo form and add fields that correspond to the ones your had in your Smartsheet. Create a dataset or use an existing set to gather form responses. Python - can be used to automate the creation of forms, or populate forms. Or integrate…

Try this formula: DATE_FORMAT(STR_TO_DATE(LEFT(Date + hour, 8),'%Y%m%d'), '%Y-%m-%d') STR_TO_DATE(LEFT(Date + hour, 8),'%Y%m%d') extracts the date portion in the format YYYYMMDD. DATE_FORMAT() function converts the date into the YYYY-MM-DD format, which should be sortable.

That doesn't seem to paste well. Here's a screenshot. It doesn't seem to recognize padding-right or padding-left. But it does recognize padding: 0px 0px 0px 0px; where each pixel number represents in order: top, right, bottom, and left.

This works… CONCAT('<div><a href="', 'www.yahoo.com', '", "target="_blank"><img src="','yoururl/images/jate.jpg','" height="42px" style="vertical-align:middle"><span style="vertical-align:middle;padding:0px 0px 0px 20px;">', Title`,'</span></a></div>')

Something like this? Last week case when YEAR(`Date_Column`) = YEAR(CURRENT_DATE() - INTERVAL 1 WEEK) and WEEK(`Date_Column`, 1) = WEEK(CURRENT_DATE() - INTERVAL 1 WEEK, 1) then `amount` end week previous case when YEAR(`Date_Column`) = YEAR(CURRENT_DATE() - INTERVAL 2 WEEK) and WEEK(`Date_Column`, 1) = WEEK(CURRENT_DATE()…

Sorry…the space doesn't show in the webpage. CONCAT('<div><a href="', Front End URL,'", "target="_blank"><img src="',`thumbnail_url`,'" height="42px" style="vertical-align:middle;"><span style="vertical-align:middle;">', '&nbsp;', `Title`,'</span></a></div>') Oh wait…your inside of a CONCAT. Add the space as '&nbsp;'…