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

How to add more data (not Field) in Dimensions?

Dearl all,

       I have the bar chart bellow with a distribution of quantity of each classification. In my table I'm using the column [Value1] in Dimensions and Count(Value1) in Expressions.
       My range is from A to Z but I don't have any values with classification A,B,I,O,Q,S,T,U,V,W,X,Y and Z, and because of this, the letters aren't showing in chart.
       I have another column [Class] with letters from A to Z.

       I'd like to show all letters even with 0%.

       How can I do?

Labels (1)
1 Solution

Accepted Solutions
BlondeThursday
Contributor III
Contributor III

Perhaps like this?

(please see attached)

 

View solution in original post

3 Replies
Lisa_P
Employee
Employee

Rename your Value1 field to Class and it will associate with the Class field and all values will be there in your chart
FabioP
Contributor II
Contributor II
Author

Dind't work... See in attached file what happend when I did what you sugest.
All values was included but was counted as one unit too... I'd like to do this only counting the values from only one of the columns not from both. Including the dimension in the Axes but without couting in the percentage.

BlondeThursday
Contributor III
Contributor III

Perhaps like this?

(please see attached)