How can enable a filter for a field that contains percentage value

I have a few column fields that contain percentage values, how can I add them to the control tab to filter based on percentage value. For example - how many customers have more than 10% etc.

you can make a filter that checks a field and uses a number.

You can also change the aggregation ect.

It won’t have the % on it but you can also multiply whatever decimal you have by 100 and use that as the new calculated field so that it goes from 0 → 100 instead of 0 → 1


Thanks, Max. This solves it

1 Like

Thanks for helping the community out by marking this as Solved @sarawgia! Thanks, as always, @Max, for your great solutions!