Formula to group numbers

Get Help
1

Hello

I would need assistance with a metabase query. :slight_smile:

On my query I have 1 column with the ID user, and 1 column with "shift" with random numbers.

I would like the following to show up:
The amount, or percentage of users with "shift" between 1 and 50.
The amount, or percentage of users with "shift" between 51 and 100.
etc...

2ED4003D-0D91-48C6-8474-D3C89030241A
2ED4003D-0D91-48C6-8474-D3C89030241A512×958 46.9 KB

Thanks for your help!

2

Hi @victoeien
Do you mean binning?
I don't think I fully understand what you're trying to do, but perhaps you are looking for the Custom Expression function Share: https://www.metabase.com/docs/latest/questions/query-builder/expressions-list#share