ArborRose Coach

The behavior you're encountering happens because Domo cards are designed to handle data and interactivity in the form of filters rather than custom JavaScript events like onclick. Custom HTML or JavaScript is often sanitized or blocked for security reasons. Bricks are your best bet for custom scripts, but if you want to…

I don't think there is any way to disable the '+Add Filter' option in the filter control on App Studio. But there are other ways you can limit the filtering options. Card Filters on specific columns, custom filters, permissions and roles to restrict datasets, etc.

@jlrosenlof - The API has the tag list as an array. In my code above, I'm only pulling based on the tag "Jupyter". But the API does show an array for the datasets that have more than one tag.

I assume last updated is when the code was last update, not the data. I need to know the code ran and data was populated via the API it was calling.

Thanks for the note. When I'm debugging code, I often use a temporary token with a quick expiration. One odd thing I found about the API, it doesn't contain information in the field dataLastUpdated.

No, you cannot directly copy just one tab of an app to another app. You would have to replicate the contents by exporting the cards and reimporting.

Thank you @MarkSnodgrass and @ggenovese. I had been searching different endpoints and couldn't find the correct one. @ggenovese , the endpoint you listed was what I needed for my search. After a bit of exhaustive code changes, the following will display a list of the datasets with tag "Your_Tag_Goes_Here". And all the…

The basic difference is probably the flexibility and customization in the user experience that an app provides. Dashboards are rigid in structure. With an app you can design a custom interface tailored to specific roles, tasks, or workflows. Dashboards aren't always mobile-friendly. Apps can be designed for mobile use.…

I'm not sure if you can do it with one of the existing chart types. But you could do it with a blank brick. In this example, I'm cheating and using a translation of longitude and latitude to plot the zip codes. To do it properly, you would need to append your data with long, lat or find a conversion method to plot them by…

Sounds like the Cloud Amp outputs may not be supported by Dataset Views. There may be a limitation, especially if the dataset originated from Cloud Amp integrations like Data Bricks. You could check if the Cloud Amp output could be exported or transformed into a Domo dataset through a dataflow or by saving it within Domo…

One of the biggest things I suggest to anyone is to try to make sure everything is dynamic and self processing. As the quarter moves, the year turns…I don't want to have to touch anything. Instead of labeling things with static values like 2024 and 2023, it's CY (Current Year) and PY (Previous Year) …and after that P2Y,…

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…