G
Guest
I have a query which calculates a percentage based on 2 values. So I have 4
columns in my query:
Week Ending Date, Drops, Calls, Calls2Drop
The query is grouped by week ending date, includes the sum of drops and the
sum of calls, and a percentage that is Calls2Drop(which is
SumOfCalls/SumOfDrops). Simple.
Now I am trying to create a line chart with Week Ending Date being the
x-axis and the Calls2Drop percent as the value. All it will let me use is
Count(Calls2Drop). I just want the exact value from the query represented on
the chart, not a count of the values. When I try to change the SQL to only
include Calls2Drop instead of Count(Calls2Drop) it tells me it is not part of
an aggregate function in the query. Why should it have to be? How do I get
around this? Any help is appreciated.
columns in my query:
Week Ending Date, Drops, Calls, Calls2Drop
The query is grouped by week ending date, includes the sum of drops and the
sum of calls, and a percentage that is Calls2Drop(which is
SumOfCalls/SumOfDrops). Simple.
Now I am trying to create a line chart with Week Ending Date being the
x-axis and the Calls2Drop percent as the value. All it will let me use is
Count(Calls2Drop). I just want the exact value from the query represented on
the chart, not a count of the values. When I try to change the SQL to only
include Calls2Drop instead of Count(Calls2Drop) it tells me it is not part of
an aggregate function in the query. Why should it have to be? How do I get
around this? Any help is appreciated.