コメント
-
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?
-
In the post @ColemenWilson is referencing, the optional group by is the second value. I was formatting the first dropdown and not looking at format on the second dropdown.
-
Can you confirm the API token has full permission to access the events? There may also be something blocking it, like a rate or size limit by the Okta API.
-
There's the issue to be resolved - there is no way to know what a user sees. There should be a shadow/proxy functionality where an admin can shadow an account to see what they see. I would suggest that when an app is shared, a dialog box inquires whether to share all cards rather than it be automatic.
-
I've done something like this by injecting a column into the dataset using a calculated field. As long as the name is the same, including the case. Later, I circled around and used the field with real data.
-
I agree with @ColemenWilson. That isn't currently an option. However, you may be able to create beast mode calculations for median to obtain something usable. Using engineer for one axis and project for another. PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY Ticket Cycle Time) OVER (PARTITION BY Engineer, Project) across all…
