If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Bar chart with Y1 & Y2 axis

Started by SGD, 14 Sep 2011 04:10:24 AM

Previous topic - Next topic

SGD

Hi,

Could please anyone suggest me how should I calculate following data items.

1) No. of Vehicles exceeding 30m Rad: count of (distinct vehicle ID) from 'Table A' for the given date period (e.g. lat 12 months) where (Table A.AoA value between 30 and 100 or Table A.AoA value < -30)
2) Total no. of Vehicles: count of (distinct vehicle ID) from 'Table A' for the given date period (e.g. lat 12 months)
3) % of Vehicles over Site exceeding 30m Rad: (Object of Point 1/Object of point 2)*100

I am trying to create a bar chart in which I need to show 'Month-Year' on 'X' axis, Point 3 on 'Y1' axis and Point 2 on 'Y2' axis.

Do I need to create 2 different queries? if yes then how can I join both the queries to see desired result? Otherwise is it possible to achieve this functionality in single query?

Your suggestions are highly appreciated. Thanks in advance.
Regards,
S.G.D.

Arpitagrawal9

i think this can be achieved in a single query,what you can do is you can first create 2 queries and the union those results.Finally you can have Y1 and Y2 axis to show Ur results