ArborRose Coach

Comments

  • {Code sent.}
  • I don't know about connectors, but you could collect PayCom via SFTP. Such using Jupyter workspace (Python). Let me know if you would like a code template.
  • Unfortunately, as of now, Domo does not automatically hide menu options for features that users lack permission to access. I agree - "I get that Domo wants to promote interest in the features, but it's super annoying!"
  • This feels like a deflection from the actual issue. The main concern here is the inconsistency in padding when embedding dashboards and our ability to control it.
  • Domo generally updates when there is data. If it doesn't see data it won't update. You could maybe do a UNION with something to indicate no rows exist. SELECT * FROM your_table WHERE some_condition UNION ALL SELECT 'No Data' AS column1, NULL AS column2, NULL AS column3 WHERE NOT EXISTS ( SELECT 1 FROM your_table WHERE…
  • @DavidChurchman - I really like this trick. How about maybe point up or down based on budget? Up arrow: ↑ (Unicode: U+2191) Down arrow: ↓ (Unicode: U+2193) Up-pointing triangle: ▲ (Unicode: U+25B2) Down-pointing triangle: ▼ (Unicode: U+25BC)
  • Wow, that's a really clever approach @DavidChurchman. I did not catch that it was a bullet chart vs a horizonal bar.
  • How about I try explaining this way. Apologies as I make up some quick sample data. I'm going to use quantity, price, calculated total, and a budget per order. Let's assume this is my data: OrderID Product Budget_Type Quantity Price OrderDate Budget 1001 Widget A Sales 5 25.0 2025-01-15 80 1002 Widget B COGs 2 50.0…
  • Make sure scipy.optimize is installed. It should be pre-installed in the Domo Python environment. import pandas as pd from scipy.optimize import minimize The Python tile will use Pandas DataFrames. Something like this. import pandas as pd from scipy.optimize import minimize # Assuming your input data looks something like…
  • Set a formula based on budget_type with something comparing actual performance against budget. CASE WHEN `Actual Amount` >= `Budget Amount` THEN 'Green' WHEN `Actual Amount` < `Budget Amount` THEN 'Grey' ELSE 'Blue' -- Optional default color if you need one END Then go to chart properties > color rules and map colors to…
  • Sorry, I was getting ready for a meeting but I thought that resource might have some relevant information so I posted it. Do you not see "alerts" on the menu in the middle? It's shown on your screenshot.
  • https://domo-support.domo.com/s/article/360043430513?language=en_US
  • @calvert_schaefer - I previously mentioned our Finance team uses Power BI. I helped them get ODBC configured to connect with Domo, they handle their own Power BI refresh. Set Up the Domo ODBC Connection on the Gateway Machine: Install the Domo ODBC driver on the same machine where the gateway is installed. Configure the…
  • @Bhargavi - Although I haven't done this specific thing myself, I believe you can write code in Python using Jupyter Workspaces in Domo, and make SQL calls. Consider the following… import domojupyter as domo import pandas as pd import pandasql as ps # Replace 'dataset_id' with your actual dataset ID from Domo dataset_id =…
  • This really isn't a Domo question. Managing training would be something dictated by your HR department using a LMS (Learning Management System). An LMS can help track successful training completion and provide quiz questions with a digital acknowledgment form confirming they understand the material. You could use Domo to…
  • A Domo Workflow with a form component and automated access granting could manage this. Create Video Cards – Upload your videos as cards and control access. Build a Form – Use a form component to create a quiz related to the video content. Set a Pass Threshold – Require users to achieve a certain score to proceed. Automate…
  • lkjlkj. sswei diio aa. 1. ljij lilj8a 2. iojoi
  • There has been a suggestion posted asking Domo to give us a default value ability based on formula or at least set it to curdate(). Over 100 upvotes but alas, we are still waiting.
  • {removed, duplicate}
  • {removed, duplicate}
  • Yes, you can use your embedded image. @MarkSnodgrass has a trick for that. Mark's cool trick - If you create a quick note card with a graphic, you can right click in your browser to see the source. This shows the Domo embedding, which can be used to host an image inside of domo. If the card is deleted, Domo still holds the…
  • Here's an example using your image. (Although I would improve this by using Inkscape to export the proper images and overlays). https://embed.domo.com/cards/ZY13R My images are self hosted…see the placeholder in html code. You will need to host the images and modify the paths accordingly. When you hover over the bin, you…
  • I don't know where Domo posted the Canva Challenge submissions from last year. Mine was a blank brick showing Japanese Cherry Blossom dates, integrated to Domo data. Move your cursor over an image on the map and it would overlay the data for that location. https://embed.domo.com/embed/pages/wmzPz If your image is svg in…
  • Mine is Yang Water Tiger.
  • @DeborahAnderson - you should post your question as a new question so the forum community can read it in entirety. A quick response…. DomoStats and Domo Governance Datasets collect data on dashboard views and provide insights on dashboard or card views, user activity, date and time. Since your dashboards are embedded in…
  • @csteele - As @MichelleH stated, you should be able to use variables for start and end dates. The variables will show up under the variable tab on the card. They can be placed on the dashboard for user selection. In a formula, reference the variable like you do a field name (backticks).
  • @MarkSnodgrass - While Mark may already have the answer to this, others seeing this post may not. You can access the pro-code editor via the Asset Library. https://domo-support.domo.com/s/article/000005500?language=en_US#access_the_pro-code_editor
  • Bump. Are we still waiting on this? How many other requests have over a hundred up votes? I concur with @Jones01, not just default to current date, but to a beast mode formula would be ideal.
  • In December, I made my New Year's Resolution to stay off the leader board in this forum {sad face}. My response to the question was that you can identify the most recent load date with a query, and use that to filter your query so it's increment (only gets the newest information). I haven't looked at any of the NetSuite…
  • You are still attempting to aggregate in a beast mode calculation. I was assuming a group by tile to aggregate.