Urgent - Need help in creating Grouped Bar Chart

[sayadutt]

Hi Team,

I have a requirement where I need to show some bar graphs grouped by some conditions.

The data i have is:

Division	ProjectName	ApplicableforTracking	GoLiveDate
A	xx	Yes	2/2/216
A	yy	No	2/15/2016
C	zz	Yes	03/12/2016
B	xx	Yes	2/2/216
A	yy	No	2/15/2016
B	zz	Yes	03/12/2016
C	xx	Yes	03/12/2016

And below is the graph i am looking for. (sample only, no link with data and graph)

Thanks in advance!!!

[kkkumar82]

Take first dimension as Division , second dimension as Apllicable for tracking and measure as Count(Project Name)

Thanks

Kiran Kumar

[sayadutt]

Hello,

How to get the x-axis dimension then? Based on GoLive Month? Feb-16, March-16 etc

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[kkkumar82]

Hi,

Please find attached?

Kiran Kumar

[avinashelite]

1.add Monthname(GoLiveDate) as dimension 1

2.add Division as dimension 2

add two expression like below

count({<[ApplicableforTracking]={Yes}>}Divison)

count({<[ApplicableforTracking]={No}>}Divison)

and go to presentation tab and check the stacked bar chart option

[ramasaisaksoft]

Hi Satyantan,

I hope u need to take 3 Dimensions Month,Division and Tracking

exp like :Count(project Name)

[pooja_sn]

Find attachment.

[santhosh_k_n]

Hi Sayanta,

Try applying Trellis available in the Dimension tab.

make sure u have placed dimension in correct order.

BR,

SK