Why yes, yes this is a dashboard.
I hope everyone reading this is safe and well. Us in Melbourne are halfway through the Stage 4 lockdown period and spirits are low. So today we will do something fun like adding Emojis to your dashboards for sparkle and pizzaz.
We know that colours are a powerful communication tool. Our eyes are drawn to patterns and colours which makes data easier to analyse. With that said, Emojis add another layer of visual communication that sometimes words cannot portray.
Where to find it:
- Windows users: Windows key + period (.),
- Mac users: Ctrl + Cmd + Space on your keyboard
- Or simply, right click on the browser search bar and you should see
- Alternatively, search and copy from https://emojipedia.org/.
All set? Let’s go.
Here are examples of how it can be used on some chart types:
Time Series Chart
How to do it: Edit data source > Create field > create a case statement
Haven’t done a case statement before? Briefly, a case statement is conditional logic to determine a field value. It is similar to the IF THEN statement in Excel.
A sample case statement in Google documentation:
Here’s how I did mine for Gender:
A case statement allows insertion of emojis in the ‘then’ formula. Do the keyboard shortcuts above, or right click between quotes and the pop up should appear, or paste from https://emojipedia.org/.
Right-clicking reveals the pop-up:
Insert your chosen emoji!
Emojis are best used in dimensions as representation in metrics can be fiddly. You may have to group your metrics then apply an emoji if you wish to.
Do you track and collect feedback on pages? We can use Emojis here too. Here’s how to set one up using Google Tag Manager if you’re thinking one might be beneficial to your website.
On Data Runs Deep, this feedback form sits below our blog pages:
In a pivot table after data clean up with the help of custom fields, this is what I will see:
That’s perfectly fine as it is, but with Emojis, the thumbs up and down captures my attention quicker than the words “yes” and “no”.
How to do it:
You can do a really silly one too, if you want to. Of course goes without saying that this may not be for your C-suite/management’s eyes unless they have a good sense of humour...
Limits of Emojis
- Emojis stay the same size, they do not resize with charts.
- Takes a bit of work to find the right Emoji for representation. This goes into design planning for your dashboard.
- Your imagination, really.
Stay well, stay sane, see you soon!