sales leaderboard - showing profile picture on the chart

Thuy_Tu
Thuy_Tu Member
in Cards, Dashboards, Stories

Hi,

I'm on the mission of building a sales leaderboard. I searched around and found a sales leaderboard from Domo that looks like this

Screenshot 2025-05-16 at 1.29.37 PM.png

Can you please show me how to get the profile picture shown in the chart like that? I searched around and the only instruction I saw was using CONCAT on HTML table. This is not that.

Thanks!

Answers

  • ArborRose
    ArborRose Coach
    edited May 16

    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.

    image.png

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • MarkSnodgrass
    MarkSnodgrass Coach

    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
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories