Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
berryons
Contributor
Contributor

Dividing a field into two

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?

2 Replies
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
Contributor
Contributor
Author

@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.