ArborRose Coach

@MattTheGuru - We shouldn't have to have extensive work arounds for something as basic as padding. App Studio gives better padding options but even NIL or zero pixel padding isn't zero. I can't even get a Domo logo to align left with a card due to padding and width limitations.

You might be able to create some kind of timestamp. But you would probably have to keep a history or something. CASE WHEN created_at > DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY) THEN 'New Row' ELSE 'Existing Row' END

Create a Unique Identifier: Ensure that your dataset has a unique identifier for each row. If not, you can create one using a combination of columns with something such as CONCAT(Column1, '-', Column2) Set Up the Initial Dataflow: Create a dataflow that will serve as the initial baseline for your dataset. This dataflow…

This example will show you how to do recursion.

Grrr…I can't seem to response to this question. My responses aren't showing up. Perhaps a graphic will work. For cards with html capability….

Domo is somehow not seeing my back ticks.

Make sure you have your conditions exculsive. CASE WHEN Sale Liability >= 50000000 AND Sale Liability < 100000000 THEN '$50M-$100M' WHEN Sale Liability >= 100000000 AND Sale Liability < 250000000 THEN '$100M-$250M' WHEN Sale Liability >= 250000000 AND Sale Liability < 500000000 THEN '$250M-$500M' WHEN Sale Liability >=…

Sounds like you have already done a few of the main things needed to troubleshoot the issue. You enabled sync and verified the schema. I recently posted (still viewable as unanswered) about my brick dataset not showing in the brick with the same schema as I see it outside the brick. It is converting decimals to integers.…

There are many syntax errors in what you typed. DAYOFWEEK(last_update) was used to find the weekend days. If you take out that reference, there's no need for DAYOFWEEK. You are also only putting your parens () around the first statement not the whole group. It was SUM({A}) / COUNT({B}). Etc.

You could probably use an ETL to join the list and make it dynamic.

How about using DAYOFWEEK(last_update) NOT IN (1, 7) to make sure only weekdays are used? SUM(CASE WHEN DAYOFWEEK(last_update) NOT IN (1, 7) AND last_update BETWEEN DATE_SUB(CURDATE(), INTERVAL 15 MONTH) AND CURDATE() THEN 1 ELSE 0 END) / COUNT(DISTINCT CASE WHEN DAYOFWEEK(last_update) NOT IN (1, 7) AND last_update BETWEEN…

Calculate the total number of open tickets per month. Calculate the average number of open tickets per month. SUM( CASE WHEN last_update BETWEEN DATE_SUB(CURDATE(), INTERVAL 15 MONTH) AND CURDATE() THEN 1 ELSE 0 END) / COUNT(DISTINCT CASE WHEN last_update BETWEEN DATE_SUB(CURDATE(), INTERVAL 15 MONTH) AND CURDATE() THEN…

Manasi mentions a possible beast mode calculation. You can create a calculated field that will categorize suppliers into selected supplier and all others. CASE WHEN Supplier = Selected_Supplier THEN 'Selected Supplier' ELSE 'All others' END Or us WHEN Supplier in (A, B, C, etc).

@Elnaz - I was responding to your question by showing you an example of how conditional formatting in a flex table may be implemented. I'm trying to assist while I am working my own projects, meetings, etc. Hopefully so you can apply the example to your data and needs. As Michelle mentions, your solution may only require…

Sample data (sample.csv) Month Sales Change Expenses Change Jan 10 5 Feb -5 -10 Mar 15 -8 Apr -3 12 Expenses Change Color: CASE WHEN Expenses Change > 0 THEN 'red' ELSE 'green' END Sales Change Color: CASE WHEN Sales Change > 0 THEN 'green' ELSE 'red' END Color rules (under properties):

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…

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 the dataset values are not plotting on my map because the dataset is somehow…

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…