I’m hoping someone can help because I’m pulling my hair out, I’m not an SQL expert but I know enough to to be dangerous.
I can’t seem to get my Graph to display properly despite following the “Example with one value and one metric column” located here
I am trying to pull out information out of a SQL database which runs a service desk. I want to have a series graph that has the techs name “v_rpt_Service.Resolved_By” as the metric, their average time to resolve “v_rpt_Service.Resolved_Minutes” as the value and the time series is taken from “v_rpt_Service.date_entered”
I have set the X-Axis Mode to “Series”
Every time I try to run the query it says “mssql: Column ‘v_rpt_Service.date_entered’ is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.”
I know it may be glaringly obvious but I’m stuck
Apologies if I have posted this in the wrong spot, any help appreciated!
v_rpt_Service.date_entered as time,
AVG(CAST(v_rpt_Service.Resolved_Minutes AS float)) AS Value,
v_rpt_Service.Resolved_By as metric