Forum Discussion

kuma's avatar
kuma
New Member
4 years ago
Solved

Regroup Values to make less objects showed in Column Legend?

Hello:   I have a dataset similar to below:   cost date name 100 2022/6/13 main-name-1 101 2022/6/13 main-name-2 102 2022/6/13 main-name-3 103 2022/6/13 subname-a-1 10...
Need Help
Dhacd's avatar
Dhacd
Icon for Resolver III rankResolver III
4 years ago

Create a new calculated column by using the below formula

   Subname= left(name,len(name)-2)

add the new calculated column to the categories and it will be working. Reply if you have any doubts,

Mark as a solution if this works for you.

Thanks and regards,
Atma.

kuma's avatar
kuma
New Member
4 years ago

Hi Dhacd

 

Thank you for your reply.

I think this would help.

 

BTW, when I use 'create group' on this field, the value in new groups is settled automatically like below:

Is the any way I can manually edit the text displayed in legend?