ArborRose Coach

I don't know about whether it does it "easily". You would need to create a table in Domo where users can select date comparisons between two periods and see the data along with the percentage change. Create two Beast Mode fields to capture the start and end dates for both periods. CASE WHEN `date` BETWEEN '2024-09-01' AND…

You can manually export the data from Google Ads and then import it into Domo or Looker Studio. Go to your Google Ads account. Navigate to the "Campaigns" tab. Apply the necessary filters to display the "Demand Gen Product Feed" campaign. Export the data to a CSV or Excel file. You can create a custom solution using Google…

The totalDuration field in the DomoStats Card Loads dataset represents the total load time in milliseconds for all card loads on a given date. To get the total load time for each card, you need to aggregate this by card ID. Regarding embedded cards, the DomoStats Card Loads dataset does capture load times for embedded…

If your date is less than the current date in the current year, it's YTD. If you do a previous year, you have to include the statement date less then the date minus a year, which is the comparison date for previous year. You can subtract an interval of days or subtract an interval of year. SUM( CASE WHEN YEAR(`date`) =…

If you set all three of the datasets (dataset0, dataset1, dataset2) to your dataset, you can remove the Example Sales Data. But be careful, removing it without changing all can wipe out the brick.

I don't think there's a direct connector. You probably have to use a combination of Azure tools, export methods, etc. Workbench, Python or something to import into Domo. You could try PowerShell scripting… Install-Module AzureAD Connect-AzureAD #Use cmdlets like Get-AzureADUser and Get-AzureADUserLastSignInActivity to…

The Bitly Connector in Domo typically provides data on link clicks rather than QR code scans directly. Bitly’s standard metrics focus on tracking clicks on shortened URLs. If QR code scans are linked to Bitly shortened URLs, you would see the data on those clicks, but the connector does not differentiate between scans and…

I would think that filtering would limit the incoming dataset before any of the brick code occurs. From that point, it would be up to your code in JavaScript to deal with the changes. Order of processing. It seems like you are trying to put a condition on the code that might be trying to put back data that isn't there at…

If your brick dataset is on dashboard with filters against the same dataset, it should filter on its own. Filters must have the same field name. And Javascript is case sensitive..make sure you type the field names exactly the same.

Here's an example. Note that my dataset0 is set for Example Sales Data. This would be set to your own dataset. Javascript: var domo = window.domo; var datasets = window.datasets; // get the data domo.get(`data/v1/${datasets[0]}`).then(function(result){ var tableHTML = "<table><tr>"; // Extract headers and make them bold…

Review the different ways in Domo to drill down from summary to detail records. Including how pfilters work. But you have to have the level of detail you want in a dataset. There are numerous forum conversions and documentation pages.

I used to work for a large school district. I've done that type of thing before using SQL. I'd just apply the same strategies to creating it in Domo. My initial attempt would be to create a Magic ETL because of the speed of execution. When you talk about schools and "levels", you can get into all kinds categories and…

I don't know whether it's available via the Meta API, you'd need to check the documentation. Assuming Threads data is available through either Meta or its own API, you can use Domo connectors to retrieve using JSON No Code Connector or a Custom Connector. JSON No Code Connector Domo's JSON No Code Connector can be used to…

Current year would be everything where the year({your date}) matches year() of current date. Previous year up through the same day of the year would be similar but you subtract 1 from the year and need to add a qualifier where {yourdate} must be less than one year prior. So CY and CTD (current year to date) are the same.…

SUM( CASE WHEN ID1 = 1 THEN 1 ELSE 0 END + CASE WHEN ID2 = 1 THEN 1 ELSE 0 END )

Your post assumes the problem is in the path. https://developer.ukg.com/hcm/docs/soap-services That type of error sounds like a Javascript error. But it does not point at being a path issue. It could be due to mismatch in configuration params or some field information not properly set. Check for any API changes in version.…

In Domo, the ability to back date an alert depends on how the alert is configured and triggered. Typically, alerts in Domo are set up to monitor data in real-time or based on scheduled data updates. The situation that existed with the dataset probably no longer exists in the same state. That would require your records to…

To roll back to a prior version of the Domo Excel add-in, you typically need to uninstall the current version first and then install the desired version. Uninstall the Current Domo Excel Add-in Open Excel: Launch Microsoft Excel. Go to Add-ins: Navigate to File > Options > Add-Ins. Manage Excel Add-ins: At the bottom of…

Have you tried putting a filter card on the App? Filters (dropdown) work across App cards so long as the field is common on the dataset. Create the filter with the same dataset you have on the App. If there are more than one cards with different datasets, it will filter where the field exists in the datasets.

In Domo, the Text Box card does not provide a built-in option to transpose text directly within the card settings. However, you can achieve a similar effect by manually arranging the text in a vertical format. Such as newline after each character. If you need more control on the appearance, you could try HTML and CSS. <div…

They have a period over period card. I don't know that they could tailor to the specifics we would each desire. When you get used to making calculations, you can create formulas for current period and past. Complications - different companies and people celebrate different holidays. And Sunday through Saturday business…

ODBC stands for Open Database Connectivity, simply put, it's a connection or handshake between systems. You may have several, some for source and others for destinations or both. I have data coming into Domo through Workbench, Python, and APIs. And I have data displayed in Domo and some other data routed out to Power BI,…

Depends upon how you want to get the information back to Oracle. Yes, if you need to write data back into Oracle from Domo without using a Python script, one approach you can consider is using the SFTP Writeback connector in Domo.

It sound like an issue in the way the settings are configured. Someone writing A > B > C often means subordinates or page flows. In this case, A > B > C probably refers to parent and child folders where '>' denotes the levels of folders. C: > A\B\C Check permissions to make sure the Domo user or service account has access.…

By the way, using Python with Domo can be done through just a script file and a computer with Python installed. I have several batch files I use to run Python scripts. Each script calls the dataset from Domo using the dataset id. My scripts generally push the data to csv or Excel files for different department using…

I'm not sure of the question. A dataset in Domo is identifiable from its ID number. Open the dataset in Data and look at the URL. There will be a number there. That's the unique id for the dataset. Programmatically could access that data and pass it over to Oracle. For Domo "token" information look for the pages on…

@JasonAltenburg - The idea is to self-produce training at a low cost. I'm familiar with OBS. I didn't think about its application here but I understand the overlaying and such. I'm not familiar with Davinci Pro. I use SnagIt every day. I highly recommend it for anyone not using SnagIt already. As for where I land…I'll try…

I'm not sure if you can do conditional formatting on a value card. I'm not where I can test it. In a card that allows html like a brick, you could do something like CONCAT( CASE WHEN Talacki $ (S) TY - ALL BU < 0 THEN '<span style="color:red;">$' ELSE '$' END, CASE WHEN INSTR(CAST(Talacki $ (S) TY - ALL BU AS CHAR), '.') =…

The issue you're having might be related to how the hour (%k format) is being evaluated for ranges. DATE_FORMAT function returns a string, not an integer. What about something like… CASE WHEN NUMBER(DATEPART('hour', Opened Date)) >= 0 AND NUMBER(DATEPART('hour', Opened Date)) < 6 THEN '12am-6am' WHEN…

Something like this? Summing views in the first 30 days SUM( CASE WHEN date <= ADDDATE(published_date, INTERVAL 30 DAY) AND date >= published_date AND DATEDIFF(CURRENT_DATE(), published_date) > 0 THEN views ELSE 0 END ) This checks if the date is within the 30-day window and after the publication date. The condition…