ArborRose Coach

Check to make sure your Marketo API integration is set up correctly in Domo. Verify that the credentials and permissions are correctly configured. Also, verify that you haven't exceeded Marketo API usage limits. High API usage can sometimes lead to failed imports. Check Marketo data privacy settings and ensure that the…

A Python script is a text file containing Python code, with the extension ".py". If you are not familiar with Python as a language, you can use AI to help you. Obviously, running it from within a Domo tile is most useful for Domo integration. Running a Python script from a batch file looks like this - Running Python from…

You do not have to have access to the Python tile to use Python with Domo. In my opinion it is a useful skill to learn. You can install Python on your computer and then create code that works by executing it with a batch file. Or use Visual Code (an interface) to access Python. If you do use Python outside of Domo, to…

For Eric or anyone who wants my code, I include it below. In fact, I should include @eddiesmall, as this is method people may want to incorporate into infographics. For my purpose, I am tracking hurricane Beryl so we can keep an eye on our medical offices along its path. You can join your Domo address information with a…

https://community-forums.domo.com/main/discussion/comment/97062#Comment_97062 Yes, correct. My dataset has the values as decimal. And the schema confirms it. In my code, I created "data2" as a set of values typed in rather than the dataset. Those values plot just fine. You can see one on Dallas and another on Houston. But…

To do this in Domo, you'll need to join the two datasets and then perform some calculations to compare the billable hours against the hours paid during each bi-weekly pay period. Employee Pay Information Dataset: Employee ID, Pay Period Start Date, Pay Period End Date, and Paid Hours. Employee Work Services Dataset:…

A heatmap can be an effective way to show which features are enabled for which users. Each cell in the heatmap can represent whether a feature is enabled (e.g., Yes/No or 1/0). Pivot the data so that each row represents a user-feature combination. User,Feature,Enabled User 1,Feature A,Yes User 1,Feature B,Yes User…

Thank you for sharing your inspiring journey! It's great to hear how you overcame challenges and found direction through the Cisco 350-501 SPCOR certification. Your experience with Pass4Success's practice tests sounds really encouraging, and I'm sure it will motivate others to take the plunge. Congratulations on your…

I think we need more information about the tables and joins. But it certainly seems like it would be no problem to handle in Python. I have various daily tasks that I perform using Python. My ETLs produce the dataset I need and I use Task Manager and Python to extract them as Excel files to direct paths on our network.

@Admin - this was posted as a discussion, not a question. And yes, I would like to know if anyone has a way to "save" the order. I am still working on this AR dataset and have to reorder all the fields (the way Mark describes) every time I update my ETL.

Perhaps you can try a combination of Beast Mode calculations and the window functions? The goal is to calculate the cumulative outstanding quantity and determine if the line item is fulfilling the outstanding sales quantity or going into negative (building inventory). Running Total Order Quantity SUM(Ord Qty) OVER…

I don't believe Domo provides any way to manually reorder legend items aligned with your data. However, you could possibly "cheat" your way into it by creating a beast mode calculation that assigns a numeric value according to the symbol for each category. CASE WHEN Shape = 'Triangle' THEN 1 WHEN Shape = 'Square' THEN 2…

Create calculated fields for each variable to determine the color based on the change. These fields set the conditional colors. You can use the calculated fields to make formatting changes. CASE WHEN Sales Change > 0 THEN 'green' ELSE 'red' END CASE WHEN Expenses Change > 0 THEN 'red' ELSE 'green' END Add Conditional…

Is this possibly caused by the placement of the legend or the space available? Perhaps you could increase the resolution or the size of the export? Does it still do this if you change the position of the legend?

You’re correct that standard PPT exports and the Domo plugin for PowerPoint are generally static. The Domo PowerPoint plugin itself does not support real-time updates. Once you insert a chart or a report into PowerPoint using the plugin, it does not automatically refresh the data. You would need to manually update the data…

https://community-forums.domo.com/main/discussion/comment/97020#Comment_97020 Thank you. Please let us know CASE WHEN NOT(beta) THEN 1 END.

@MarkSnodgrass - that doesn't hold the order. As I mentioned, when the ETL is modified or an API reruns every morning the dataset order changes.

ODBC connection is in Windows > Administrator. There are two versions : 32 bit and 64 bit. You need to edit using the version that matches what was configured. If you don't find it in one, go to the other. Generally you want 64 bit for a 64 bit operating system. But sometimes compatibility leads to configuring in 32 bit.…

Welcome to the Domo Community.

There used to be a page, but it appears to have been moved or removed. https://developer.domo.com/docs/apis/data-apis/sql-api If you look at the answers to a recent question I posted, you will see that new SQL functionality is right around the corner.…

Based on documentation I have seen regarding Domo's SQL API, the following limitations apply: Joins, Subqueries, and CTEs: Joins are not allowed in the SQL API. This limitation extends to subqueries and Common Table Expressions (CTEs) as they are essentially advanced forms of joins and require similar underlying database…

Congratulations @MichelleH.

I don't think there is a specified limit. But that doesn't mean you aren't hitting an issue where it's overloading. There are many things that could be affecting it. Network issues, domain vs domain connectivity, permissions, etc. I like your suggestion to have her open a new PowerPoint and try again. Start small and work…

Interesting that so many suggest variables or parameters. I don't even think I'm using variables for anything. I have posted examples previously with the way I do this. I create an ETL with aggregates that include fields for CY, PY, P2Y, etc. The same aggregate tiles include calculations for MTD, QTD, etc. For things like…

I don't do many alerts, but you can trigger alerts on datasets, cards, or conditions in a dataflow. Alert on a dataset: define a condition for the alert such as when a value exceeds a threshold. Alert on a card, based on the same dataset you use for the brick. Or branch off in the dataflow. Alert on the dataflow, such as a…

The PowerPoint plugin is designed to work interactively with PowerPoint so I'm not sure you could do it that way. But you can probably use Python to extract the data from Domo via the Domo API. Then process it according to whatever your needs are such as filtering, aggregating, etc. Then update the PowerPoint with Python.…

Can you make an ETL and dataset that feeds the brick trigger the alert?

I may have a working solution. I will need to replace my test datasets with actual data and validate numbers.

@zcameron - that is great news. I am not normally one to champion beta features before release, but a few of these things can't come early enough for me as I stave off the angry villagers at the castle walls wanting to upper case our data.

If you move the window to the left, and then stretch your window width a bit more, you should gain access to that part that you can't reach. Take the window out of full mode and do alt+{space}, then "m". I feel for you. I have a flow that fills the width as well. Not as "elegantly" as yours though. ;)