How to consolidate small series in Grafana Pie Chart?

I’m wondering if it’s possible to summarize all series with value less 1% to “Other” seria.

Welcome

Can you use Value mapping with a range? unless you can do a

select case when 

in clickHouse