Pie chart by sum Id

[eduardo_dimperio]

Hi,

I have two fields "ID" and "Code_Desc", the ID field its not unique. How do I show the amoung of IDs that have a Code description in a Pie Chart?

[Mauritz_SA]

Hi @eduardo_dimperio 

Not sure if I understand your question right, but if you have the following table:

LOAD * INLINE [
ID, Code_Desc
1,A
1,B
2,C
2,D
3,B
4,A
];

Then you can get the following Pie chart:

By having the following in your Pie chart settings:

Dimension -> Code_Desc

Measure -> Count(ID)

Appearance -> Value Labels -> Custom -> Values

Hope this helps.

Mauritz