ArborRose Coach

Thank you. Please let us know CASE WHEN NOT(beta) THEN 1 END.

@MarkSnodgrass - that doesn't hold the order. As I mentioned, when the ETL is modified or an API reruns every morning the dataset order changes.

ODBC connection is in Windows > Administrator. There are two versions : 32 bit and 64 bit. You need to edit using the version that matches what was configured. If you don't find it in one, go to the other. Generally you want 64 bit for a 64 bit operating system. But sometimes compatibility leads to configuring in 32 bit.…

Welcome to the Domo Community.

There used to be a page, but it appears to have been moved or removed. https://developer.domo.com/docs/apis/data-apis/sql-api If you look at the answers to a recent question I posted, you will see that new SQL functionality is right around the corner.

Based on documentation I have seen regarding Domo's SQL API, the following limitations apply: Joins, Subqueries, and CTEs: Joins are not allowed in the SQL API. This limitation extends to subqueries and Common Table Expressions (CTEs) as they are essentially advanced forms of joins and require similar underlying database…

Congratulations @MichelleH.

I don't think there is a specified limit. But that doesn't mean you aren't hitting an issue where it's overloading. There are many things that could be affecting it. Network issues, domain vs domain connectivity, permissions, etc. I like your suggestion to have her open a new PowerPoint and try again. Start small and work…

Interesting that so many suggest variables or parameters. I don't even think I'm using variables for anything. I have posted examples previously with the way I do this. I create an ETL with aggregates that include fields for CY, PY, P2Y, etc. The same aggregate tiles include calculations for MTD, QTD, etc. For things like…

I don't do many alerts, but you can trigger alerts on datasets, cards, or conditions in a dataflow. Alert on a dataset: define a condition for the alert such as when a value exceeds a threshold. Alert on a card, based on the same dataset you use for the brick. Or branch off in the dataflow. Alert on the dataflow, such as a…

The PowerPoint plugin is designed to work interactively with PowerPoint so I'm not sure you could do it that way. But you can probably use Python to extract the data from Domo via the Domo API. Then process it according to whatever your needs are such as filtering, aggregating, etc. Then update the PowerPoint with Python.…

Can you make an ETL and dataset that feeds the brick trigger the alert?

I may have a working solution. I will need to replace my test datasets with actual data and validate numbers.

@zcameron - that is great news. I am not normally one to champion beta features before release, but a few of these things can't come early enough for me as I stave off the angry villagers at the castle walls wanting to upper case our data.

If you move the window to the left, and then stretch your window width a bit more, you should gain access to that part that you can't reach. Take the window out of full mode and do alt+{space}, then "m". I feel for you. I have a flow that fills the width as well. Not as "elegantly" as yours though. ;)

@AndreaLovesData I appreciate your help. If you message me your email, I can provide you a better example. Just like the one I posted but with actual data (no private information).

Hmmm. Maybe something like… Load and Sort Data: ensure that your data is sorted by the 'Date Authorized' column to process the entries in the correct order. Add a Running Total Column: Create a running total for the 'Used' column to keep track of the cumulative usage. Calculate the Spillover: For each row, determine if the…

@benschein - Those temporary tables are data examples to represent what I'm doing. My actual data is quite different (medical transactions and insurance rates). I don't have a SQL tile in Magic ETL (not signed up for beta anything).

I assume that isn't your exact code. There are comments there that don't have # symbols. And the formatting is wrong. Probably caused by the community forum interface for input. For example, you have "write your script here"….which is a comment. As if AI is asking you for a function. Consider the following Check for…

Using SQL, we can build the table using CREATE TABLE attendance ( attendance_date DATE, employee_id INT, attendance_status VARCHAR(10) ); INSERT INTO attendance (attendance_date, employee_id, attendance_status) VALUES ('2024-05-01', 909750599, 'PR'), ('2024-05-01', 909777952, 'NM'), ('2024-05-02', 909750599, 'PH'),…

Have you tried something like this: TO_NUMBER('12345', '#########') The pattern should match the format of your number. If the number varies in length, you might need a use a flexible pattern. Using 999 means exactly three digits. ######### means up to nine digits. If the strings have leading zeros, and you want to ignore…

Verify permissions in the API. Check end points const fetch = require('node-fetch'); const apiKey = 'YOUR_API_KEY'; const apiUrl = https://api.data.gov/ed/collegescorecard/v1/schools?api_key=${apiKey}; async function fetchData() { try { const response = await fetch(apiUrl); if (!response.ok) { throw new Error(HTTP error!…

You can use Beast Mode to adjust your timestamp for time zone differences. Step 1: Identify the time zone offset Determine the fixed offset between the time zones. For example, if you want to adjust from UTC to a specific time zone, you need to know the standard offset (e.g., UTC-5 for EST). Step 2: Adjust for Daylight…

Thank you for the information @JosephMeyers . As Mark mentioned, I was able to set all datasets to my dataset and then safely remove the example sets.

Live Data Mode refers to the capability of the Domo add-in to pull the most recent data from Domo into your Excel spreadsheet. When this mode is enabled, the data in Excel is dynamically linked to your Domo datasets, ensuring that you are always working with the latest available data. You may be able to creat a button…

I can't find any olo connector in the AppStore. And the documentation points to an invalid link. Where are you acquiring the connector and what is the documentation you are referencing? If this is a json API, perhaps you can use the more generic No Code oAuth Connector?

Make sure your filters are based on the same dataset as the graph. Filters work across cards, based on common fields with exact same naming.

My formula was an example to show you how you might replace spend with a formula based on specific paid ad sources. If you want a dynamic total that updates based on filters, you don't need a specific formula just for filtering if the existing data. On the card with your graph, make sure your filters are applied to the…

Have to you tried using some other connector or method of communicating? Such as No Code oAuth JSON connector? (search appstore for JSON). I'm not sure there's much we can do in the community other than sympathize with your plight. If it's any encouragement, Domo support did manage to answer a question for me this year. <g>

Have you tried something like this (below)? TO_NUMBER('12345', 'FM999999999999999999999999999999999999999999999999999999999999') The FM is an optional prefix that indicates there are no leading or trailing spaces. The nines specify a placeholder for each digit, resulting in a LONG integer without decimal.