PIE CHART

[manoranjan_d]

Hi all,

Below is the data.

SID	QID	Question category	answer	score
S1	1	AA	agree	5
S1	2	BB	disagree	6
S1	3	CC	moderate	7
S1	4	DD	neutral	8
S2	1	AA	disagree	5
S2	2	BB	agree	6
S2	3	CC	moderate	7
S2	4	DD	neutral	8
S3	1	AA	Neutral	5
S3	2	BB	disagree	6
S3	3	CC	agree	7
S3	4	DD	neutral	8

I want to display the pie chart as per the below details example:

Details

I want it for  particular  question category, not for all question category

Example:

question Category AA has agree, disagree, neutral moderate, in this i want to know the count( SID).

please help which thing has to be used in dimension and expression.

[Anonymous]

How far have you got so far ?

And what is your current stumbling block ?

[manoranjan_d]

I cant get the data for particular question category, when i use question category as dimension it showing for all question category , so i need to view the data only for particular question category

Example question category AA

has agree, disagree, neutral moderate and in that i want to know the count( SID)

[Clever_Anjos · Accepted solution]

use count({<[Question category]={"AA"}>} SID). as expression and answer as dimension

[Digvijay_Singh]

I don't understand that when you want to count SID based on question category then how does it matter the value of Answer which you are explaining in your requirements, not sure if I have valid doubt.

[ogster1974]

‌create a filter object on Question category to Swtich between your questions then create a pie object with answer as dimension and count(distinct SID) as your measure.

REgards

Andy

[manoranjan_d]

use count({<[Question category]={"AA"}>} SID). as expression and answer as dimension

got answer based on the above stmt

[manoranjan_d]

how to create filter object on Question category

[Clever_Anjos]

Add a Listbox to your application and choose Question Category

I recommend you this series of videos www.youtube.com/watch?v=ifO7pF5CLBM

[ogster1974]

‌Go to add new object and select a list box and select question category as your dimension you want to display.  Then you can remove your set analysis from your count measure and let the list box  filter determine the question category selected by the user.

REgards

Andy