ArborRose Coach

I don't have much time to respond, but it ought to be something like this: Using Magic ETL Group By the data to remove duplicates for each ProjectId and get the unique Yearly Total Run Costs (CHF) for each project. • Add a Group By tile in Magic ETL. • Group by ProjectId. • Use the MAX (or MIN) aggregation on Yearly Total…

What Grant is suggesting you try…. SUM(1) OVER (PARTITION BY ProjectId ORDER BY BatchTimeStamp) This creates a running total (cumulative sum) of rows for each project id, ordered by the batch timestamp. The first row for each project id will have a total of 1, the second 2, etc. The case statement checks to see if the…

I was thinking something similar to @GrantSmith. Using Magic ETL, group by ProjectID and use Max/Min aggregation on Yearly Total Run Costs. I always prefer to aggregate in an ETL. In beast mode, sum the run costs with something like: SUM( CASE WHEN `BatchTimeStamp` = MIN(`BatchTimeStamp`) OVER (PARTITION BY `ProjectId`)…

It's not an issue in with your dimension. The December 30, 2037 end date in Google Ads often indicates that no end date has been explicitly set for the campaign in Google Ads. Google Ads assigns this default "end date" (far in the future) when the campaign is set to run indefinitely or hasn't been manually given a specific…

Maybe, if you can calculate the content height. But there may be security reasons where Domo parent page and iframe are not allowed to communicate. See if this gives you something to work with: <script> function sendHeightToParent() { var height = document.body.scrollHeight; window.parent.postMessage({ frameHeight: height…

I generally want all my data in detail statements. Each transaction with the account, category, amount, date, type, etc on each line. Then aggregate the amounts and compile it to a final output. Something like you show, I gather from millions of rows of transactional data. Using Magic ETL, to group and sum and categorize.…

If you store the last successful created date in a Domo variable, dataset or other….you could use that as part of your SQL query -- Get the last loaded date from the tracking dataset SELECT MAX(loaded_date) as last_loaded_date FROM last_import_tracking; -- Use that date to filter new records from NetSuite SELECT * FROM…

There are different ways you could implement filters on a brick. Passing values in the URL would be one way. https://your-domo-instance.domo.com/page/12345?filtername=column_name&filtervalue=filter_value You could also use environment values: // Get existing filters from the environment (if any) const pfilters =…

Local Payroll Administration: Often, local payroll or HR administration teams manage credentials for accessing payroll and timekeeping systems. If your local team doesn’t have the credentials or is unsure, check with Dayforce support. They can provide guidance on account setup and API access. Types of credentials: User…

One of us! One of us! One of us!

Initial Pivot Table Example: Opportunity ID Opportunity Name Best Few (2024-09-22) Best Few (2024-09-15) 10711 Opportunity One 1 1 10716 Opportunity Two 1 1 10717 Opportunity Three 1 0 10718 Opportunity Four 1 0 10720 Opportunity Five 1 0 10670 Opportunity Eight 0 1 Calculated field: CASE WHEN `Best Few (2024-09-15)` = 1…

Explanation: DAYOFWEEK(CURRENT_DATE()) = 2 is Monday. If it's Monday, we subtract 7 days to get the previous Monday (e.g., on Monday, 9/30, this will return 9/23). For any other day (Tuesday through Sunday), we subtract the number of days since last Monday. The DAYOFWEEK(CURRENT_DATE()) + 5 handles this by calculating how…

Try this DATE_SUB(CURRENT_DATE(), INTERVAL (CASE WHEN DAYOFWEEK(CURRENT_DATE()) = 2 THEN 7 ELSE DAYOFWEEK(CURRENT_DATE()) + 5 END) DAY)

When you create a Beast Mode formula that involves window functions like COUNT() OVER() or certain date calculations, it might not appear in card titles, summary numbers, or filters because those sections may only accept simple aggregations. It might take it as a string: DATE_FORMAT( DATE_SUB(CURRENT_DATE(), INTERVAL (CASE…

I have a meeting to get to in a couple minutes. So this is going to be a bit rushed. Hopefully this helps… Creating a sample set: Customer Name Purchase Date Transaction Amount John Doe 2024-07-01 50.00 Jane Smith 2024-07-02 75.00 John Doe 2024-08-01 30.00 Jane Smith 2024-08-03 40.00 John Doe 2024-09-01 100.00 Mike Johnson…

How about this DATE_SUB(CURRENT_DATE(), INTERVAL (CASE WHEN DAYOFWEEK(CURRENT_DATE()) = 2 THEN 7 ELSE DAYOFWEEK(CURRENT_DATE()) - 2 END) DAY)

Let's start with whether I understand the question - you want to…. Read and analyze signed PDF contracts that are not in a structured database (just legal files). Integrate these contracts with their existing datasets, specifically: A support ticket dataset. A financial dataset. Ask questions such as: Average number of…

Looks like your code is attempting to access an iframe from outside Domo's iframe. In other words, the source of the iframe is from a different domain than Domo. <iframe id="domoFrame" src="https://<domo-url>?autoresize=true" width="100%" height="100%" scrolling="no"></iframe> Can you do the sizing in the iframe statement…

The error you're encountering, NameError: name '_jupyterhub' is not defined, indicates that the _jupyterhub object, which is likely supposed to handle AI generation requests in Domo's Jupyter integration, is not being properly recognized in your Jupyter Notebook. _jupyterhub may not be correctly imported or initialized in…

Domo has maximum number of characters for text fields as 1024, but numerical fields also have limits. For number and fixed decimal, Domo stores numbers as 64-bit floating point values (ie. Double in most databases). This give high range values, but also precision limits. If your number is large, you may have an issue with…

Note: I think Shopify has rate limits of something like 2 requests/second.

I'm not sure what you are looking for @DMJerry. I thought the responses gave insight into solutions. Shopify has an API that can be called with Domo's API connectors, or through a custom connector. Create a Shopify Private App (or API credentials): Go to your Shopify admin. Navigate to Apps -> Develop apps. Create a new…

I was told by Domo staff a year ago that things like the title and metadata were not something we could alter or customize. Due to that fact, I do not use PDF in Domo. If there is a way, I'd like to hear it.

There are settings in Admin > Authentication related to SCIM (System for Cross-domain Identity Management). There are settings for Single Sign-On, OpenID Connect (SSO), SAML (SSO), etc. Try this AI suggestion: Here’s a step-by-step guide on how to enable and configure SCIM for automating user onboarding in Domo via Okta:…

I would have thought @ColemenWilson was on the right track. If changing the type didn't fix it, it might be causes by something in your transformations. Sometimes, applying transformations in Domo (like STR_TO_DATE() for date formatting) may unintentionally cause type casting issues in other columns. CAST(`Net Change USD`…

Make sure you have back ticks on your fields, and that your field names match the correct spelling.

SUM(CASE WHEN STATE = 'Ringing' AND TIME_TO_SEC(AGENT_STATE_TIME) <= 11 AND LEAD(STATE) OVER (PARTITION BY AGENT_NAME ORDER BY DATE, AGENT_NAME) = 'Not Ready' THEN 1 ELSE 0 END)

The error looks like it has trouble trying to connect DV 360 (Google Display & Video 360) to Domo related to a permission problem or missing configuration in your Google Cloud Console project. I'm not familiar with the DV360, but here's an AI solution. Maybe it will help. API Access and Enable Display & Video 360 API in…

@khushboo_, you are the only person talking about App Studio in this discussion.

The only thing I have seen is to set the whole table's borders. Unless I have missed some ability to control specific cell, column or row borders, this is woefully inadequate.