ArborRose Coach 
コメント
-
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…
-
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:
-
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. 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 have filters on it (shown) that control…
-
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: 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.
-
No. There is another page setting dialog. If I click on this small space between my card and the scrollbar, it brings up a page settings display. At the bottom is "filter options". Click that button to get the dialog.
-
Got it. I have not braved the world of custom connectors yet.
-
FYI: In App Studio, you can go to Page Settings and change the filter options, including turn off the PDP icons.
-
I have not tried this myself. Perhaps there is a page setting in App Studio that is disrupting the functionality.
-
In Python… today = datetime.utcnow() today = today.replace(microsecond=0) past_date = today - timedelta(days=30) formatted_today = today.strftime('%Y-%m-%dT%H:%M:%SZ') formatted_past_date = past_date.strftime('%Y-%m-%dT%H:%M:%SZ') print("Current date in required format:", formatted_today) print("Date 30 days ago in…
-
What's the language?
-
I would handle it in an ETL. You have a huge dataset. I deal with 15-20Mil rows. Depending upon your data, you may be able to pull parts of transactions (such as current year, current quarter, etc) and append. I pull past years less frequently than I pull quarterly transactions. I combine the datasets to get a full set for…
-
Sounds frustrating, especially when support isn't helpful. Do you have any access to Cloudflare settings that might be blocking the Domo request? Perhaps you can request whitelisting the Domo IP address? I have had issues with connectors in the past where our networks security and firewall were blocking access or ports.…
-
The error suggests there's an issue with the SSL certificate verification. SSL is the secured socket layer (security certificate). Possibly the SSL certificate has expired or been improperly configured? Missing CA (Certificate Authority)? Or possibly the network is blocking something in firewall or port settings.
-
It sounds like domo is expecting a different Excel format. Whether that happened because of the Workbench update or a change in your files, I could not say. But it sounds like something in the update changed the way it reads the file. Domo Support would be your best bet.
