Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
See the attached qvw:
Hi,
Try like this
Dimension: DimensionName
Expression: Count(DimensionName)
Regards,
jagan.
I m not getting what exactly ur output?
Can u provide output like
1- ?
2- ?
3- ?
-Nagarjun
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
Add your value as Dimension and add expression as Count(yourValue)
add you dimension as value and expression as Count of Distinct values.
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