ArborRose Coach

Thanks David. I have Camtasia and may upgrade to the latest version for the SCORM and text to speech requirements. For an AI avatar, I may try Synthesia but I've never used it. Thus, reaching out to find out what people have used.

I don't know about the path you are seeking. But, are you aware there is a Domo ODBC connector that can connect you to your Power BI? Our Finance team uses Power BI and we use the ODBC to source our Domo data via their Power BI dashboards.

The debug tiles I used, help me "see" what is happening with the data and their values. This helps me identify the needs for the pivot. Note in the Movie 2 debug below, we see the Role_Rank that will become our new column headers.

My incoming dataset: My flow looks like this: The two outputs (Movie 1, Movie 2) at the bottom are for you to debug and see what is happening. Next I create a Rank using Row_Number. The order is by Role, Name. The partition is based on Team. Then I concatenate the Role and Rank to get the labels we want. This is going to…

Create a Pivot. Use the "Pivot" tile to pivot the Role column into new columns. Then group and aggregate by using the "Group By" tile to group by Team and concatenate the names for each role. {Urg…apologies, my solution below is a bit different than I described. We don't group by.}

Use a Third-Party ETL Tool There are third-party ETL (Extract, Transform, Load) tools that can connect to Instagram and Facebook to get data and then push it to Domo. S Zapier Integromat Tray.io Talend You could try Facebook's API. https://developers.facebook.com/docs/instagram-api

Go to Chrome Settings → Privacy and Security → Clear browsing data. Select "Cached images and files" and "Cookies and other site data." Click "Clear data." Check for Extensions: Browser extensions can sometimes interfere with the display of web elements. Go to Chrome Settings → Extensions. Disable all extensions and see if…

Control + Shift + Delete to clear your cache maybe. That's a quirk and not Domo. What happens in another browser?

It appears my issue was in the fetching of the dataset. Here's code that works. Thank you Matt. function initMap() { // Create a map centered on Texas var map = L.map('map').setView([31.9686, -99.9018], 6); // Add OpenStreetMap tile layer L.tileLayer('https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', { attribution:…

@MattTheGuru - Interesting catch. Thanks. But it won't fix anything if the dataset is defining those values as integers. {Look at the screenshots of the dataset table.}

@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…

https://domo-support.domo.com/s/article/360057087393?language=en_US 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…

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…