Pie chart

[ashokraju]

I have a scenario.I have a dimension like Duplicate number.In that dimension values are 1,1,1,2,2,2,2,2,2,3,3,3,3,3 like that.

I want to create a pie chart '1' is repeated two times i want to show one duplicate.'1' is repeated three times i want to show two duplicates like that for 2 and 3 also.

How i do this in pie chart.please suggest me.

[m_woolf]

See the attached qvw:

[jagan]

Hi,

Try like this

Dimension: DimensionName

Expression: Count(DimensionName)

Regards,

jagan.

[nagarjuna_kotha]

I m not getting what exactly ur output?

Can u provide output like

1- ?

2- ?

3- ?

-Nagarjun

[nagarjuna_kotha]

If want count of unique values thn take

Dimension: DimensionName

Expression: Count(Distinct Value)

Output:

1- 1

2- 1

3- 1

If u want count actual values

Dimension: DimensionName

Expression: Count(Value)

Output:

1- 3

2- 6

3- 5

-Nagarjun

[Anonymous]

Add your value as Dimension and add expression as Count(yourValue)

[sampada0810]

add you dimension as value and expression as Count of Distinct values.

[Anonymous]

hi,

use below expression , so that one show no of repeated  values in the list

=if (aggr(NODISTINCT count(values))>1,1,0)

regards,

Gireesh