sales leaderboard - showing profile picture on the chart

Thuy_Tu

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

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!

ArborRose

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.

MarkSnodgrass

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