Dividing a field into two

[berryons]

Hi everybody! I have an application with many fields in it. One of these fields is CategoryNames. In CategoryNames, there are hundreds of category names. One of them is "Unsufficient info", and I want to watch it specifically. I want to create a pie chart, which shows two slides, one is "Unsufficient info" the other is "Others". Thus, I can follow the current ratio which is equal to number of Unsufficient info/all category names. How can I do this?

[balabhaskarqlik]

May be try with If clause, create a dummy dimension... use that dummy dimension in Pie chart to show the percentage.

In script..

If(Match(CategoryNames,'Unsufficint Info'),'Unsufficint Info','Others') as CategoryName_Dummy... use this in pie chart...

or use the, same kind of definition in measure to create two different percentages... 

[berryons]

@balabhaskarqlik thank you for your answer. I found a solution by creating an extra field. A flag field which divides rows in two with values 0 and 1.