I want to add automated flag emojis of every country in grafana table cell, is it possible?

[shivamshekhar96]

• What Grafana version and what operating system are you using?
  12.0
• What are you trying to achieve?
• i have a country column in table, with 2 letter country ISO 3166-1 alpha-2 codes
  i want to add flag emojis of every country in grafana table cell, is it possible?
• How are you trying to achieve it?
  directly pasting unicode emojis into text field is not rendering the flag emoji
• What happened?
  for FR(France), it is just showing as : ‘FR’ , instead of flag emoji. I tried to copy emojis from other websites like emojipedia
• What did you expect to happen?
  expected a flag emoji to be displayed. like :
• Can you copy/paste the configuration(s) that you are having problems with?
  SELECT
  countrycode_ as COUNTRY,
  SUM(event_count) AS LAUNCHES,
  FROM ‘my-table’

Here i want to add another column with flag emojis corresponding to every country.

• Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

• nope, it is just not rendering.

• Did you follow any online instructions? If so, what is the URL?

• nope, just asked ChatGPT and it said it is possible, but i’m still unable to do it

Also, i want to add full name of country in another column beside 2 letter country codes, any help ?

Thanks for you time

[yosiasz]

Could be a bug in the table plugin.

here is one possible way you could do it, but those flags do not look evenly spaced

[shivamshekhar96]

Thanks for swift response @yosiasz ! This is indeed a solution.
Will check if i could get flags equal sized.

[shivamshekhar96]

I found the solution,
Apart from what @yosiasz mentioned, we can use a diffrent url that specifies height and width also, like :
https://flagcdn.com/48x36/ +<2 letter small case countrycode>+ .png
https://flagcdn.com/48x36/us.png

[yosiasz]

Another approach using Business Text and flag emoji