ArborRose Coach

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…

https://community-forums.domo.com/main/discussion/comment/93366#Comment_93366 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…

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".

https://community-forums.domo.com/main/discussion/comment/93081#Comment_93081 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…

@Ashleigh - basic table. I can't imagine a single Domo user who hasn't wanted to adjust border thickness, border color, cell merge, etc….with a basic table card. With a blank brick, and a bunch of javascript code I can do it. What a pain in the butt. Can I say "butt" on here? Apologies. See the table output below. A domo…

I'd trade the whole list for border styles, padding, and cell merge in the basic table chart type.

It looks like the JSON data structure has nested objects with unique keys. When pulling the data into Domo, each unique key is being treated as a separate column, which leads to too many columns.

It makes no sense to me why Domo lacks basic formatting (merge, border, border thickness) on a table chart. Marcel's answer is so creative it hurts my brain trying to figure out how he got the heading over the three columns.

In this example, a calculated filter placed on the FILTERS, where = 1.

There are more than one way. The one that comes to mind is to use a dropdown that is to use multiple filter cards, each filtering for a different SKU. For example, you can add two separate filter cards to your dashboard, one for SKU A and one for SKU B. By selecting both SKU A and SKU B in their respective filter cards,…

To display a timestamp in Domo with both the converted time zone (PST) and the corresponding UTC offset, use Beast Mode to manipulate the timestamp field by adding or subtracting hours (based on your location). You can calculate the UTC offset for PST (UTC-8:00) and append it to the timestamp using CONCAT.

Check for dataset compatibility. Make sure the columns being referenced exist in both. After starting the transfer, wait for the process to complete and verify that you receive a confirmation message indicating that the transfer was successful. There may be a delay as it copies. And also make sure you refresh to verify…

I don't believe merge is available on an html table. The following shows how you can do it on a blank brick.

Have you considered some type of dropdown where the user can set their timezone in a dropdown and your dashboard adjusts by adding/subtracting from UTC time?

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Intl/DateTimeFormat/resolvedOptions I believe you can get the timezone in Javsascript using Intl.DateTimeFormat().resolvedOptions().timeZone. See link above.

In the JSON No Code connector that Grant describes, you will see some configuration fields for parameters. It might be easier to understand looking there. When parameters are passed to an API, they are either passed in line, like HTML does it on webpages. www.mysite.com?param=1 Or they are passed as part of a header…behind…

And you could create a bar chart such as… quartername: CASE WHEN QUARTER(date) = 1 then 'Quarter1' WHEN QUARTER(date) = 2 then 'Quarter2' WHEN QUARTER(date) = 3 then 'Quarter3' WHEN QUARTER(date) = 4 then 'Quarter4' END Expand on the chart by setting filters with your selection of year. Or include year as part of the…

If you put your data in a format like the webform below. You can use it as a source on a Domo card and let the card do the aggregation (finding the number of per whatever) In this case, I'm showing months and year. Just add a function for quarter where the formula is quarter([date]) and add it to the columns. Note, the…