ArborRose Coach 
Comments
-
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…
-
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)
