Folks,

I'm trying to add a line graph chart to a form that lists "run date"
along the x axis, "value" on the y axis, and the actual line of the
graph is the metric being tracked from my database. For added clarity,
the label is cross referenced to another table, giving me the following
query to use as a basis for the chart:

SELECT Release.Release_Metric1, Run.Run_Metric1, Run.Run_Date
FROM Release INNER JOIN Run ON Release.Release_ID = Run.Run_Release;

To explain a little, the Release table holds the "names" of metrics
applicable for a particular release ID, and the Run table holds the
actual metric values.

Anyway, when i go through the insert chart wizard, pointing it to the
above query, it is invariably turned into the following rowsource for
the chart:

TRANSFORM Count([Run_Metric1]) AS [CountOfRun_Metric1] SELECT
(Format([Run_Date],"MMM 'YY")) FROM [GraphQuery] GROUP BY
(Year([Run_Date])*12 + Month([Run_Date])-1),(Format([Run_Date],"MMM
'YY")) PIVOT [Release_Metric1];

The result being a single horizontal line, value "1", since for all
release / run combinations, there is of course, only one value for
"Metric1". I want the actual value stored in "metric1" for that
particular "run".

Muchos Gracias!

Steve

Ok, Seems I found it myself... simply change "Count" to "Sum" .....
Duh!


On Jan 25, 10:20 am, "Renster" <steveh...@hotmail.com> wrote:
> Folks,
>
> I'm trying to add a line graph chart to a form that lists "run date"
> along the x axis, "value" on the y axis, and the actual line of the
> graph is the metric being tracked from my database. For added clarity,
> the label is cross referenced to another table, giving me the following
> query to use as a basis for the chart:
>
> SELECT Release.Release_Metric1, Run.Run_Metric1, Run.Run_Date
> FROM Release INNER JOIN Run ON Release.Release_ID = Run.Run_Release;
>
> To explain a little, the Release table holds the "names" of metrics
> applicable for a particular release ID, and the Run table holds the
> actual metric values.
>
> Anyway, when i go through the insert chart wizard, pointing it to the
> above query, it is invariably turned into the following rowsource for
> the chart:
>
> TRANSFORM Count([Run_Metric1]) AS [CountOfRun_Metric1] SELECT
> (Format([Run_Date],"MMM 'YY")) FROM [GraphQuery] GROUP BY
> (Year([Run_Date])*12 + Month([Run_Date])-1),(Format([Run_Date],"MMM
> 'YY")) PIVOT [Release_Metric1];
>
> The result being a single horizontal line, value "1", since for all
> release / run combinations, there is of course, only one value for
> "Metric1". I want the actual value stored in "metric1" for that
> particular "run".
>
> Muchos Gracias!
>
> Steve