ArborRose Coach 
コメント
-
I think its risky to share the parent app if you share a card. I have an app with gauges, dials, tables, etc. This app is intended for an executive team to see the big picture. Someone in a department may be able to view one of the cards, but that does not mean that person should be able to see the cards out of their…
-
Sorry, I don't know what a Phoenix brick template is.
-
You are showing the "Show value as" option. What do you see when you click the "Format >", just below that?
-
I haven't used the email connector, but the documentation says you can specify the Excel Sheet Tab Number (optional). https://domo-support.domo.com/s/article/360042931954?language=en_US
-
I do the same (aggregate through an ETL), then granulate any further calculations on the javascript code. The one I'm doing right now has a dozen columns with delta over year and % of delta. A couple formulas you may find helpful: const formatCurrency = (value) => '$' + value.toFixed(0).replace(/\d(?=(\d{3})+$)/g, '$&,');…
-
I'm assuming you don't have this working. I'm just now getting a chance to look back at your comments. Here's an example using EXAMPLE SALE DATA, written in the way you have your example setup. HTML: <!DOCTYPE html> <html> <head></head> <body> <div id="collintest"></div> </body> </html> Javascript: var domo = window.domo;…
-
Based on the error, 502, it seems there may be a problem with the other server. The backend server hosting the data.
-
Your code looks correct. I don't see an issue there. Perhaps there's an issue with something else. Check your column names and make sure you follow the case sensitivity, like capitalization. Verify you are on dataset[0].
-
https://community-forums.domo.com/main/discussion/comment/96235#Comment_96235 Yes, the trouble is trying to get it to give a most recent based on the data it has filtered or unfiltered. And then displaying it as text (so it can be used as a caption). David's answer doesn't put it in a text box, but it provides the same…
-
Sure. Create a card with a filter. Or create a report to identify clients with whom you no longer have business based on their order history. MAX([Order Date]) OVER (PARTITION BY [ClientID]) as Latest_Order_Date Filter Clients with No Recent Orders: Once you have the latest order date for each client, you can filter the…
-
There are cards in the app. Share the cards to the people using the app. I may be able to see the app dashboard but denied permission on specific cards.
-
They are using "team" as group. Add a group using the admin section so that dashboards can be assigned to everyone on that "team" by granting access to the group.
-
I might try something like creating a Magic ETL and use location and trans date to sort rows in ascending order. Add a formula and find the location date differences. Calculate the averages. Then have some kind of formula to classify the sale frequency. CASE WHEN Avg_Date_Diff <= 7 THEN 'Weekly' WHEN Avg_Date_Diff <= 14…
-
Sure. As long as the field you want to filter on exists with the same name (same case) in both sets, it will filter across all cards on the app page.
-
I don't know about the default line chart. But I can do it in a brick. <html> <head> <script src="https://cdn.jsdelivr.net/npm/chart.js"></script> <script src="https://cdn.jsdelivr.net/npm/chartjs-plugin-annotation"></script> </head> <body> <canvas id="myChart"></canvas> </body> </html> const ctx =…
-
I would research the coalesce command. Coalesce([fieldname], 0) would give zero if [fieldname] is null.
-
You could try something like this in Python… Sorry, the code doesn't want to paste into here easily. Adjust code below to what shows above. import requests Domo API credentials client_id = 'your_client_id' client_secret = 'your_client_secret' access_token_url =…
-
Using the link I posted, you can set a user default landing page. But when I attempt it using an app, it doesn't appear in the list.
-
Ah…here's the link I was looking for… https://domo-support.domo.com/s/article/4409575159191?language=en_US
-
Users can set their own default page. I'm not sure if you can force one on them. Here's the link to Domo default page settings: https://domo-support.domo.com/s/article/360043439093?language=en_US
-
Unsure if this works yet, but it appears that the setting for "search" needs to be left blank. Our previous attempt had "transactions" . We've re-run the report in Domo and NetSuite and we are getting the right row count now. My finance crew will need to validate and confirm before I call this solved.
-
Hopefully I can provide enough to get your started. If I were using Python, I would start with authenticating with the Domo API. Get a client id and secret id through the developer portal. import requests Replace with your actual client ID and secret client_id = 'YOUR_CLIENT_ID' client_secret = 'YOUR_CLIENT_SECRET' Get an…
-
Yes, the error indicates there may be an issue with processing the Excel file. If you are sure on the location, name, tab names, and such…you might check formulas, file size (too large?), corrupt file, permissions, etc. Can you test with the copy of the file without formulas? Copy the Excel file contents and paste back…
-
Based on your description, you want three tables with totals for each of Product, City, and Store. https://embed.domo.com/embed/pages/D9npn Each table card shown would be alike, with a different dimension in the first column. There would be no beast mode calculations needed. And if each card uses the same dataset, you can…
-
When importing data into Domo, it might not recognize it as a date and treats it as a plain number. The result you see as that big number instead of a date. You can try converting the numeric back into a data format. Or try changing it at the Google sheet. DATE_ADD('1899-12-30', INTERVAL NumericDate DAY)
-
Here's a public link to my freemium page app that incorporates a webform: https://embed.domo.com/embed/pages/W7ENW If it doesn't let you see the code, let me know. [edit] Ah…reviewing what I did. (sorry…I forgot how I built it) I created an ETL to a dataset. Then I use the dataset as the source in the app.
-
Do you want the app to use the webform or contain a webform? I created an app for the Canva challenge that uses data from a webform. You edit the data in the normal webform, and the app makes use of it.
-
Or…avoiding nesting fixed functions: sum( sum(Total LTV) fixed (by Year, Dimension 2, Dimension 3) ) / sum( sum(Total Orders) fixed (by Year, Dimension 2, Dimension 3) )
-
Perhaps you could try something like this, wrapping the entire calculation in another fixed function: sum( sum( sum(Total LTV) fixed (by Year, Dimension 2, Dimension 3) ) / sum( sum(Total Orders) fixed (by Year, Dimension 2, Dimension 3) ) ) fixed (by Dimension 2, Dimension 3)
-
What is the error you are receiving? Without the error message it's a bit hard to pinpoint the issue.
