Currently, if you calculate the average of a rating field, where some have been unrated (either they did not apply or they are scheduled for the future), the avg formula will rate those as 0s. I think unrated should not count in the average as most people understanding the rate system to be 1 star is the worst rating and 4 stars the best (not 0 to 5).

If you do a Count of the rating field, the count will ignore the unrated ones, which works differently then the way avg works.

Of course a work around is a sum of all the ratings divided by the count. However this does not work in any charts in dashboards, as the average function is hardcoded.

Also, it would be nice if you could have "⭐️⭐️⭐️⭐️★ 4.1" along with the number as an output.