ArborRose Coach

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. ;)

@AndreaLovesData I appreciate your help. If you message me your email, I can provide you a better example. Just like the one I posted but with actual data (no private information).

Hmmm. Maybe something like… Load and Sort Data: ensure that your data is sorted by the 'Date Authorized' column to process the entries in the correct order. Add a Running Total Column: Create a running total for the 'Used' column to keep track of the cumulative usage. Calculate the Spillover: For each row, determine if the…

@benschein - Those temporary tables are data examples to represent what I'm doing. My actual data is quite different (medical transactions and insurance rates). I don't have a SQL tile in Magic ETL (not signed up for beta anything).

I assume that isn't your exact code. There are comments there that don't have # symbols. And the formatting is wrong. Probably caused by the community forum interface for input. For example, you have "write your script here"….which is a comment. As if AI is asking you for a function. Consider the following Check for…

Using SQL, we can build the table using CREATE TABLE attendance ( attendance_date DATE, employee_id INT, attendance_status VARCHAR(10) ); INSERT INTO attendance (attendance_date, employee_id, attendance_status) VALUES ('2024-05-01', 909750599, 'PR'), ('2024-05-01', 909777952, 'NM'), ('2024-05-02', 909750599, 'PH'),…