Question

I’m writing a formula to show my goal progress with stars, and my formula is like this:

slice("⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐", 0, round(prop("percentage") / 10))

There should be 2/5/6 stars for each line, but why doe it not work properly?

Answer 1

Emoji count as two characters, try with this:

slice("⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐", 0, round(prop("percentage") / 10) * 2) 

Hope it helps :)

Answer 2

As @polle mentioned a lot of emojis don't register as one character so the slice function doesn't play very nice. Unfortunately some emojis register as even more than two characters, so you might have to do something like the following for other emojis.

replaceAll(slice("xxxxxxxxxx", 0, round(prop("percentage") / 10)), "x", "⭐️")