App Development

[YanivZi]

I have a table with two columns, on of ID and the other of numbers. 

ID	NUM
8997765	0
8899654	1
8889777	2
8888554	9
8889776	50
8877954	100
8885532	105

How can  i turn it to this?

COUNT(ID)	NUM (fixed string)
3	0-9
2	9-99
2	100+

[brunobertels · Accepted solution]

Hi 

May be with a calculated dimension based on NUM :

=if(NUM<9,dual('0-9',1),
if(NUM<99,dual('10-99',2),
if(NUM>=100,dual('100+',3))))

i used if statement aned dual function to make order by 0-9 10-99 and 100+ easier 

mesure is count(ID)