Best Of

Re: Is there a best practice for a visual indication that a card has a drill down configured?

Oh, I didn't know that shortcut! I usually just Google something like "unicode triangle down" and copy/paste from the web… inefficient but effective

DavidChurchman

2

Re: what kind of SQL does DOmo use

@Data_Devon Thank you!

Abe

1

Re: Is there a best practice for a visual indication that a card has a drill down configured?

@BryantCafferty I like to use a symbol like this triangle and then add a description that describes what they will see if they drill:

Screenshot 2025-05-20 at 11.32.00 AM.png

ellibot

3

Re: sales leaderboard - showing profile picture on the chart

If you have your Domo users add a profile picture in their Domo profile, you can access that picture by using the following URL:

https://{instance-name}.domo.com/api/content/v1/avatar/USER/{userid}

If you have the DomoStats People dataset in your instance, you can use ProfilePictureURL column as your image source in your html.

If the pictures aren't stored in in their Domo profile, you can do a one-time upload onto a dashboard and note the URL that is created and then add that to your code. I explain how to do that in this video (around the 7 minute mark)

https://youtu.be/mZlxTS4s81I

MarkSnodgrass

1

Re: sales leaderboard - showing profile picture on the chart

For mine, I had to host the image on my own server or use a trick to host it locally on Domo. There's a past thread here in the forum that shows that trick.

Then use html as a DIV in the data that points to the image.

Here's the beast mode formula:

CONCAT('<div style="text-align:center;border:0px white;border-collapse:collapse;"><img alt="DOWN" height="190px" src=','"https://{webhostdomain}.com/images/doctor/',`doctor_id`,'.png"','>','</div>')

The links you see showing the CONCAT statement IS that. Notice in my beast mode that I am referencing an identifier field. Same thing, you create your chart or table or whatever and embed the html with reference to your Domo field. But you need to make sure your files are already hosted on a reachable server or linkable in Domo. I can't find the original thread where I commented about this.

ArborRose

1

DomoStats: AI Chat Sessions

In response to customers asking for more insights into how their users are utilizing AI Chat, there is now an ‘AI Chat Sessions’ report available in the DomoStats connector.

This report will help you understand how and where your users are engaging with AI Chat.

Ken_Boyer

1

Re: Can I move a formula in the list of "Group by" actions?

It would definitely be an improvement to be able to reorder aggregate columns in Group By. Column order as a whole is not given the attention it deserves in Magic ETL.

This workaround may be unwelcome; in most cases this will be more of a pain than just redoing the aggregates from the point where you want to reorder them. But in extreme cases where you have a very large number of aggregates, this is probably quicker:

1. Drag-select the Group By and at least one other tile to bring up the multi-tile control sidebar.

2. Click "Copy to Clipboard".

3. Paste into a text editor (ideally a code editor). This is the JSON definition of the copied tiles. Unfortunately, it is compacted; it's all on one line and has no indentation. A code editor will probably be able to reformat it for you so it's readable. Barring that you can use a JSON formatter website to do the same, but I'd be cautious of these if there is anything sensitive in the formulas themselves (not likely but possible).

4. You're looking for the Group By "fields" part of the JSON:

5. You can now use cut and paste to reorder these fields. Make sure to keep the JSON valid (commas must separate the fields and a comma after the final item in the array is not allowed).

6. When you're satisfied with the order, copy the entire document to your clipboard and paste it back into the Magic editor.

This is in no way a good solution for your problem, but I figure there's a small chance it's helpful in the future if you find yourself in a situation where you need to reorder a single aggregate in a list of dozens, or if you ever need to do something else that our editor won't let you do.