ArborRose Coach

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. 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. Domo's connector may rely on specific versions…

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…

Thanks David. I have Camtasia and may upgrade to the latest version for the SCORM and text to speech requirements. For an AI avatar, I may try Synthesia but I've never used it. Thus, reaching out to find out what people have used.

I don't know about the path you are seeking. But, are you aware there is a Domo ODBC connector that can connect you to your Power BI? Our Finance team uses Power BI and we use the ODBC to source our Domo data via their Power BI dashboards.

The debug tiles I used, help me "see" what is happening with the data and their values. This helps me identify the needs for the pivot. Note in the Movie 2 debug below, we see the Role_Rank that will become our new column headers.

My incoming dataset: My flow looks like this: The two outputs (Movie 1, Movie 2) at the bottom are for you to debug and see what is happening. Next I create a Rank using Row_Number. The order is by Role, Name. The partition is based on Team. Then I concatenate the Role and Rank to get the labels we want. This is going to…

Create a Pivot. Use the "Pivot" tile to pivot the Role column into new columns. Then group and aggregate by using the "Group By" tile to group by Team and concatenate the names for each role. {Urg…apologies, my solution below is a bit different than I described. We don't group by.}

Use a Third-Party ETL Tool There are third-party ETL (Extract, Transform, Load) tools that can connect to Instagram and Facebook to get data and then push it to Domo. S Zapier Integromat Tray.io Talend You could try Facebook's API.

Go to Chrome Settings → Privacy and Security → Clear browsing data. Select "Cached images and files" and "Cookies and other site data." Click "Clear data." Check for Extensions: Browser extensions can sometimes interfere with the display of web elements. Go to Chrome Settings → Extensions. Disable all extensions and see if…

Control + Shift + Delete to clear your cache maybe. That's a quirk and not Domo. What happens in another browser?

It appears my issue was in the fetching of the dataset. Here's code that works. Thank you Matt. function initMap() { // Create a map centered on Texas var map = L.map('map').setView([31.9686, -99.9018], 6); // Add OpenStreetMap tile layer L.tileLayer('https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', { attribution:…

@MattTheGuru - Interesting catch. Thanks. But it won't fix anything if the dataset is defining those values as integers. {Look at the screenshots of the dataset table.}