ArborRose Coach

https://developers.google.com/youtube/v3/determine_quota_cost I've never pulled from YouTube, but here's my guess. On the page link, it mentioned a default of 10,000 units per day. And the reports endpoint costing 10 units per call. And one unit request for things like videos, playlists, etc. It seems to suggest that to…

Based on review of multiple support sites, the following apparently are NetSuite supported. Function NetSuite Support Notes _1 ----------- ------------------ ------- ADD_MONTHS(date, integer) Yes Returns the date plus the specified number of months. LAST_DAY(date) Yes Returns the date of the last day of the month for the…

Try WHERE TH.TRANDATE >= TO_DATE('2024-01-01', 'YYYY-MM-DD') I don't think Netsuite knows the SQL version YEAR().

It sounds like the reason Domo can’t authenticate your Trade Desk account is due to the multi-factor authentication (MFA) you mention, which prevents standard username/password logins for API connections. The workaround is to use API credentials instead. Can Trade Desk provide a Client ID and Secret specifically for API…

This sounds like a feature request rather than a question. Is the following (below) a correct summation? If so, maybe a forum admin could move it to Feature Request: Improve Filtering and Visibility in Execution List Summary Currently, the Execution List in Domo does not allow filtering or searching by recipient (e.g.,…

Domo ETLs executions are trigger based, not condition. It won't trigger on a condition specifically. You would have to simulate a dataset change or something to get the flow to run. Such as having an ETL filter rows where INVOICE LIKE '%,%'. If not rows match the dataset won't change. If rows do match, the flow would…

Create a table card. Drag your category colum to the rows. Drag the category column again to the values and set aggregation to count. Category Count Text1 2 Text2 3 Text # 3 1

Besides the question Colemen asked, I'd also ask about that inner join you show on the first row. You are selecting columns previously and then inner joining. If the column you want is not in the selected columns of the other side, how would the inner join find it on both sides?

Yes, its possible. Time zones shift by hours, centralized on UTC (Universal Time). Depending upon the local time zone, you shift so many hours. In Dallas, I am 5 hours off UTC time…depending upon daylight savings. Meaning when it's 1 PM in Dallas, it is 6 PM UTC. DATE_ADD(`utc_datetime`, INTERVAL `user_offset_hours` HOUR)…

Let’s break this down : Initial row count: 32,168,003 Later row count: 32,190,212 Change: +22,209 rows Now review your alert rule in your post: Rule Any row has changes for column(s): 'Row Count, Tag' Row Count decreases by 1 Tag is equal to audit:frequency That’s a bit confusing, because the UI sometimes shows decreases…

Could your data types be affecting the alert? It looks like exponentials versus float may be affecting the logic.

Here's a break down of the way I was thinking. Apologies my docking unit just died and I have no monitors. I'm not used to using a laptop screen…lol.. AppointmentID,AppointmentDate,Provider,Metric 1,2024-06-15,Mitch,1 2,2024-07-20,Justin,1 3,2024-08-05,Kristin,1 4,2025-01-10,Kristin,1 5,2025-02-22,Kristin,1…

lol….Yeah, who's Brent? I don't see anything where you designate the % split across time. One way you could do this is to organize something to show the date duration and split %, maybe something like: Provider Galley Split % Start Date End Date Mitch John 100% 1900-01-01 9999-12-31 Justin John 100% 1900-01-01 9999-12-31…

Via Domo Governance Datasets you can find information about cards, pages, datasets, flows. However, governance metadata is more aligned toward dashboards/pages, datasets, and access, rather than specifically marking app to card linkage.

Thanks for the response Grant. In light of pydomo not supporting upsert - I rewrote my code to extract the existing data, combine it with new extracted data from the API, then remove duplicates and replace the data back to Domo. Due to the duration of Python run and credits consumed, I moved my testing to Visual Studio…

Lol…no. I can't stand using CLI and Jar files. I'd almost rather shoot myself in the toe and watch myself bleed out. Is that the only way to put a primary key on a dataset?

Yeah, that sounds buggy. Have you tried to create just a one or two entries using add columns? And then go back over and edit all?

I agree with Grant based on my experience with the Domo No Code Connector. This issue probably stems from changes on the Domo side—unless your IT team recently updated your network or proxy settings. Vendors usually don’t change their APIs often, but if the endpoint recently updated its authentication, request headers, or…

I don't think so. Beast mode can handle calculated fields but can't create a new total on a pivot table. They operate on row level, not summary. You can do the formula you show, but it won't add a separate total row in the pivot. Using Magic ETL you should be able to group by account, sum the MTD per account across regions…

Yes, I had that same problem and never got it to work properly. https://community-forums.domo.com/main/discussion/69027/workflow-help-identifying-a-form-submitter-and-sending-an-e-mail

Looks like your are aggregating inside the row logic. Domo re-evaluates the case when it calculates the Grand Total instead of summing the row results. I'd try creating two beast modes CASE WHEN `Revised Estimate (fixed by Estimate)` = 0 AND `Cost to Date (fixed by GL)` <> 0 THEN `Cost to Date (fixed by GL)` WHEN `Cost to…

I wish I had all the answers but I don't know the answer to your original question. Many things that could affect the issue. Also I don't do a lot of PDP. Possibly the user is a member of a group that has broader access. Possibly the conditions of your policy aren't filtering, ie the condition isn't truly restricting the…

PDP policies work the same in apps as they do in cards. See previous post: https://community-forums.domo.com/main/discussion/67220/how-do-i-change-pdp-policies-in-an-app-like-i-can-on-a-dashboard

See this previous post: https://community-forums.domo.com/main/discussion/67182/filter-persistence-between-pages-within-app-studio Per Domo knowledge article, you can create a filter view and set it as default for every app viewer. https://domo-support.domo.com/s/article/000005295

As far as I know, Domo does not support exploding the output - where each selection in your multi-select becomes its own row automatically. I believe there have been requests asking for this feature (turning multi-select selections into separate rows.…

As I mentioned, you could try to build out something that calls the Domo API. Maybe someone has code out there. In a brick or procode, I'd try something like: <button id="exportBtn">Download Dataset to Excel</button> With some kind of JavaScript or other code that looks something like this: import * as XLSX from "xlsx";…

Not really. Not in the way you are looking for. Domo’s native export options (Excel, CSV, PDF) are limited. You cannot control formatting, add dynamic headers/dates, or create multi-section, report-style layouts purely through Domo dashboards. Exported Excel files will be basic tables without merged cells, advanced…

Beast mode associates with the data used on the card, not the card or the page it rests on. It does not have access to the metadata about the page. And a card could be placed on more than one page. I have cards in Overview that are also on different dashboards. You might find workflow could help you. They give you more…

Congratulations on your certification! Safe space? The best? I am a potato. I put on a helmet and a seatbelt before entering the forum.

To duplicate that example, make sure you set your dataset0 to the sample products dataset. The code is referencing this as ${datasets[0]}.