ArborRose Coach

@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. https://domo-support.domo.com/s/article/360042928254?language=en_US 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…

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.

It sounds like you're trying to create a dynamic segment that updates based on filters, reflecting the total spend of filtered paid ad sources in your line graph. Assuming you have a dataset that includes columns like Date, Paid Ad Source, and Spend. CASE WHEN Paid Ad Source IN ('Amazon', 'Facebook') THEN Spend ELSE 0 END

I haven't worked with Postgre in a minute. But based on your description and some googling…it seems the error is looking for you to check that you have your protocol set using method as scram-sha-256 in the pg_hba.conf configuration file. Found in the PostgreSQL data directory. I'm not sure it will make a difference to the…

Perhaps this might help.. <!DOCTYPE html> <html> <head> <title>PDF Generation Example</title> <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.4.0/jspdf.umd.min.js"></script> </head> <body> <!-- Your infographic content here --> <div id="infographic"> <h1>My Carbon Offset Infographic</h1> <p>This is where your…

That appears to be a Content Security Policy issue….restricts the resources a web page can load based on domain policy. As if your frame (Domo portal) violates the security by attempting to frame another domain.

I haven't seen a brick with only one. I thought I had tried remapping all three but I just tried again and it worked. Thanks @MarkSnodgrass.

For paginated data, you might try something like this: else if (metadata.report == "Vulnerabilities") { // Define base URL and API key var baseUrl = "https://api.appcheck-ng.com/api/v1/" + metadata.account.apikey + "/vulnerabilities"; var allData = []; // Function to fetch data for a specific page function fetchPage(page)…

What you are doing above is basically a solution that should work. The lack of connection shouldn't be because of Domo. I suspect a network issue, firewall, lack of VPN login, or something in the connection to ZD1.

You don't need to import a card to reuse. Go to the card and find "add existing card". Search by card titles.

Look under admin > tools for schema management. You can alter your datasets there.

Click the link that says submit a product idea.

Thanks @david_cunningham. It's something we should all be doing. And in most cases - legally required. https://www.ada.gov/resources/web-guidance/

Could be several reasons: authentication method. URL and parameters such as filters or date ranges. Javascript errors. Security policies. Network issue. You might even try clearing your browser cache and refreshing.

Yes, you can have filters across all cards on the app page. The filters do not persist across pages or to other cards. If there's a way in the app studio, I haven't seen it. As for persisting across pages or cards, I'm sure you could create something that stores a filter value from one card and affects a card on another…

Instead of using the default numeric format, can you create a calculated field (or beast mode) to convert the number to a string without commas? Use a formula like CONCAT('', number) to ensure the number is treated as a string, which typically won't have commas. CONCAT('', ROUND(number_field, 0)) CONCAT('$',…

@LearningNinja, what is available in the dropdown labeled "Format" at the bottom of your screenshot? Is there an option for thousands comma selector there?