Bar chart

[manoranjan_d]

Hi,

In my bar chart i have 5 bars which shows with the counts and  with different departments such as IT, CSE,EEE, ECE, MECH

all these has to be displayed as  single bar with there counts how to do that?

pls help me

[MK_QSL]

Remove Departments from Dimension Tab

[manoranjan_d]

@ manish when i remove dept from dimension i getting single bar only but the dept is not segregated in a single bar, its showing over all total count only...

[jonathandienst]

Your requirement is not very clear. Do you mean a single bar with coloured segments for each department?

Of so, remove the dimension and make one expression for each department:

     =Sum({<Department = {'IT'}>} Values)

     =Sum({<Department = {'CSE'}>} Values)

     ...

[manoranjan_d]

yes with single bar , that has to show the count of eact dept.

department	Count per Department
IT	50
CSE	100
MECH	200
EEE	150
ECE	130

[MK_QSL]

Create a Bar Chart

Add a Calculated Dimension

=1

Untick Show Legend

Lebel

use

department as 2nd Dimension

Expression

Whatever your expression is

Tick Values on Data Points

Go to Style tab and select Stacked..

Go to Presentation tab and tick

Plot Values inside segments

still show total on top

Go to color tab and tick persistent color

[manoranjan_d]

how to show these data in percentage

[manoranjan_d]

@manish how to show these single bar in precentage

[MK_QSL]

COUNT(Department)/COUNT(Total Department)

[manoranjan_d]

all things good but when i reviewed ur file u r using same fields of department.

but my data is having like this

department	Count per Department
IT	50
CSE	100
MECH	200
EEE	150
ECE	130