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.
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