ArborRose Coach

Sounds like you need to do a left join on the matching tables and then a calculated field that says {columnname}: CASE WHEN {value in A} IS NOT NULL and {value in A}<>'' THEN {value in A} ELSE {value in B} END

Let's see if I have this correct….you have data that looks like this… You create a report that looks like this… But you want to unpivot the data so you can see All Sales, then all LBs, and all Cases. We can take the sample2.csv data and run it through an ETL to create Sample3.csv. Which gives us this.. And put that on a…

Assuming data looks something like my sample below, you could create a percent of total and then rank those. With a rank you can decide whether to display them ascending or descending and how many by filtering or setting the limit rows value. Dimension Value Totals A 50 200 A 30 200 A 40 200 A 80 200 A 100 200 B 20 150 B…

When I click the plus sign on the overview section and save, it saves there no problem. Where are you starting the card?

Can you show us any kind of mock up of what you are doing currently with your spreadsheet? There are quite a few forecasting videos and Domo examples on the web. Have you reviewed any of them? I would first look to the forecasting tile in the Data Science are of the Magic ETL…link…. There are also videos posted. Based on…

I do it as Grant mentioned - add an output on the dataset can give you a dataset to debug. I label that output set with the word debug so they are easy to find and remove afterwards.

You should be able to programmatically log into Domo using Domo's API OAuth 2.0 authentication to give you an access token. Register your app to get client credentials (client ID and client secret) through the developer portal. Implement the authorization to get an access token and redirect back to your application. Not…

It doesn't sound like a Domo issue. Sounds like something that needs to be addressed in the HTML and javascript code used to display the form. Different browser platforms have different compatibilities. Its typically the developer that needs to address the code to make things work.

This link may be helpful… There are lots of tools to use and different ways to do things. I guess it depends upon your familiarity with using command line interfaces over other tools or languages like Python.

Have you checked the date range on the card to make sure it includes all dates? In your screenshot it looks like you have limited the dates.

To apply the logic you mention, you'll need to come up with a formula for the avg of the current months visits. And count working days. CASE WHEN WEEKDAY(Date) NOT IN (1, 7) THEN 1 ELSE 0 END And something to calculate the average visit per working day. SUM(CASE WHEN YEAR(Date) = YEAR(CURRENT_DATE()) AND MONTH(Date) =…

The formula might be something like: sum( case when YEAR(date) = YEAR(DATE_ADD(CURRENT_DATE(), INTERVAL 1 MONTH)) and MONTH(date) = MONTH(DATE_ADD(CURRENT_DATE(), INTERVAL 1 MONTH)) then visit else 0 end ) Assuming you have entries for visits next month. Change the interval to get other future months.

I can't find any links to a livestream for 2024. And a filter on the forum doesn't show any mention. I concur with @DomoDork. I think we have to wait for links to be sent out after events finish. But here's an image you can view while you wait. lol…

I've shared my method recently. I create formulas for CY, PY, P2Y (current year, previous year, previous 2 year)….or month such as month to date compared to previous year month to date…..using a formula where the formula compares the date in data with the current date. If you want year to date or month to date, add a line…

In Domo, if I want to display an image, I call up images that are hosted on a website I control. I shared the code on a link this morning. Read recent discussions and you will find it. I can repost it here if needed. I've done it by storing files in a database in image format, but that wasn't in Domo. Or, I store the…

What kind of witchcraft is this? What does it do? It looks like it lets you redefine the schema on a dataset. I spent months working with Domo when we first started because the dataset schemas on our API calls were not defining properly. I do have admin access. It is all flagged as premium. It looks like you can focus on a…

CONCAT('<div style="text-align:center;border:0px white;border-collapse:collapse;"><img alt="DOWN" height="190px" src=','"https://{domainurl}/image/',image_id,'.png"','>','</div>') I use the above beast mode formula.

You can create a filter to set up options that a person can search for, using something like [Merchandising Direction] LIKE '%${dropdown_filter}%'. If you want to search for a custom string, you probably need to implement something using a variable. I like Grant's suggestion of using a brick. But creating the code would be…

I'd look to make sure the personal access token has sufficient permissions to access the specific catalog. Although you have admin access, the specific catalog permissions might be different. Make sure that you have the necessary permissions to access the tables within the catalog. Specific tables may have different…

There are various ways I could think to tackle this. In one scenario, I wrote a bingo program where I randomly selected from a thousand avatar images that I had created using AI. I stored a few thousand and made sure they balanced out demographically - race, gender, etc. If my data knew the gender and race, it fit the…

I would try accessing the Google Drive API. Or see if you can pull it using Python. I have done similar things with large JSON data…but not from Google. My sources come from other places.

When it happens to me, I take a screenshot as a placeholder so I can remember how I configured the card. Then I open a new tab and verify my login to make sure I still have an active connection to the server. If you don't or can't see Domo….log in in that other window. Get the session going and the first window will…

Here's the way I do it in Python. In your comments, you use "Authentication". But in both of our code examples, we're showing "Authorization".

Yes. But my comment didn't mention color. The thumbnail below is the report I mentioned earlier in the discussion…

Is that word "Basic" supposed to be in the authentication value? That doesn't look like part of the base 64 string.

Curious….when I create an ETL and build a rank and formula for top sales, it aggregates Other just fine. When I try to do it on the card itself, it can't seem to aggregate Other. It tries to display all Other individually. Although I tried to eliminate all other columns from the dataset.

The error seems to indicate you need to address the pivot where you have more than one match to a location. You don't show any sample data so its difficult to guess where it sees an issue. Check your CASE statements to make sure you are categorizing the data properly with no logic errors in multiple categories. Make sure…

Under the admin settings there is an activity log. You need administrator privileges to see it.

It may be that some of the values are null. Have you tried using coalesce? Something like… CASE WHEN RANK() OVER (ORDER BY COALESCE(SUM(`Sales`), 0) DESC) <= 10 THEN `Country` ELSE 'Others' END Also, verify your data doesn't have any type mismatch.

@BenSchein - unless I just don't know how to use it, that general setting is completely useless. I don't want to change ALL borders or outside border, we need to separate columns for readability. There's not a single table I have ever built where I wanted an ugly outside border and unreadable rows. I don't want any App…