ArborRose Coach

@JasonAltenburg - The idea is to self-produce training at a low cost. I'm familiar with OBS. I didn't think about its application here but I understand the overlaying and such. I'm not familiar with Davinci Pro. I use SnagIt every day. I highly recommend it for anyone not using SnagIt already. As for where I land…I'll try…

I'm not sure if you can do conditional formatting on a value card. I'm not where I can test it. In a card that allows html like a brick, you could do something like CONCAT( CASE WHEN Talacki $ (S) TY - ALL BU < 0 THEN '<span style="color:red;">$' ELSE '$' END, CASE WHEN INSTR(CAST(Talacki $ (S) TY - ALL BU AS CHAR), '.') =…

The issue you're having might be related to how the hour (%k format) is being evaluated for ranges. DATE_FORMAT function returns a string, not an integer. What about something like… CASE WHEN NUMBER(DATEPART('hour', Opened Date)) >= 0 AND NUMBER(DATEPART('hour', Opened Date)) < 6 THEN '12am-6am' WHEN…

Something like this? Summing views in the first 30 days SUM( CASE WHEN date <= ADDDATE(published_date, INTERVAL 30 DAY) AND date >= published_date AND DATEDIFF(CURRENT_DATE(), published_date) > 0 THEN views ELSE 0 END ) This checks if the date is within the 30-day window and after the publication date. The condition…

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…