Something Silly: Random Emojis in your Dashboard Indicator

547
0
04-03-2023 11:11 AM
Labels (1)
jcarlson
MVP Esteemed Contributor
7 0 547

Do you have any "to do" dashboards in your organization? I do! These often come with a big indicator: items left to do. I like to use conditional formatting in those indicators to make getting to 0 more satisfying. It's a small thing, but it's surprising how often I hear about it from my users.

Judging by the feedback I receive, this is really all the people want.Judging by the feedback I receive, this is really all the people want.

Now, I get it. Most dashboards (especially public-facing ones) probably ought to be more professional. But if nobody's forcing you to make a dry and soulless infographic, why not loosen up a little?

Believe it or not, I actually got a feature request recently to take the emoji idea further: could I make the emoji change randomly?

Of course I can!

Get your indicator set up the way you want, and just slip this little bit of Arcade into your Advanced Formatting code block, adjusting the list of emojis to your liking:

var emojis = [
    '😻',
    '🏆',
    '🏅',
    '🥇',
    '🎉',
    '🥳',
    '🙌🏾',
    '🥂',
    '🎂',
    '🍾'
]

var emoji = emojis[Floor(Random() * (Count(emojis)-1))]

Then reference the emoji variable in the returned middleText property.

Here it is with a short refresh interval:

Peek 2023-04-03 13-03.gif

Now go make your dashboard a little more fun to look at!

About the Author
I'm a GIS Analyst for Kendall County, IL. When I'm not on the clock, you can usually find me contributing to OpenStreetMap, knitting, or nattering on to my family about any and all of the above.