topic Re: Sort data into two categories in App Development

Sort data into two categories

andreacossu1 — Sat, 16 Nov 2024 21:44:57 GMT

Hello.

I have some data that needs sorting. The problem is that once the if condition is fulfilled by a value, that value gets sorted and cant be accessed again. As an example, say I need to sort one value into two categories. For the sake of the example let this be that I have the following task:

If([color]='red', 'red',

if([color]='red','RGB,'not assigned))

So basically I want to assign the value 'red' to its own category and to 'RGB'. How is that done?

I've been struggling with this for a long time now.

Thank you so much!

Re: Sort data into two categories

PradeepReddy — Tue, 11 Dec 2018 10:11:53 GMT

you can categorize any value into one classification bucket at a time..

to achieve the your requirement, try to create 2 separate fields instead of 1 field...

If([color]='red', 'red','not assigned') as Calsifcation1,

If([color]='red', 'RGB','not assigned') as Calsifcation2..

you can try like this also..

If([color]='red', 'red-RGB','not assigned') as Calsifcation3

Re: Sort data into two categories

andreacossu1 — Tue, 11 Dec 2018 12:33:10 GMT

Thanks for the reply, I see your point. However, how can I access these new created buckets?