Chart Type:
Area
Bar
Curve
Line
Pie
Pyramid
Stacked Bar
Chart Width:
px
Chart Height:
px
Data Markers:
None
Circle
Cross
Diamond
Horiz. Line
Marble
Triangle
Vert. Line
X
Chart Grid:
None
Horizontal
Vertical
Toolbar:
On
Off
Query:
SELECT Site.SiteCode AS Site, Parameter.ParamCode, AirFact3.FactDate AS [Date], AVG(NULLIF (AirFact3.FactValue, - 999)) AS [Value], Program.Caption AS Program, Site.SiteID AS SiteID, Site.SiteName AS SiteName, Site.Latitude, Site.Longitude, Site.ElevationMSL AS Elevation FROM AirFact3 INNER JOIN Program ON AirFact3.ProgramID = Program.ProgramID INNER JOIN Site ON AirFact3.SiteID = Site.SiteID INNER JOIN Parameter ON AirFact3.ParamID = Parameter.ParamID WHERE (Program.ProgramID IN (10005)) AND (Site.SiteID IN (1,6,31,57,78,96,99)) AND (Parameter.ParamID IN (102,104,112,153))AND (AirFact3.FactDate >= '1/1/2005') AND (AirFact3.FactDate <= '12/31/2005') GROUP BY Site.SiteCode, Parameter.ParamCode, AirFact3.FactDate, Program.Caption, Site.SiteID, Site.SiteName, Site.Latitude, Site.Longitude, Site.ElevationMSL ORDER BY Site.SiteCode, AirFact3.FactDate, Parameter.ParamCode
Split Field:
Row Fields:
Column Fields:
Value Fields:
Show Data Point Legend:
False
True
Show Series Legend:
False
True
Show User Legend:
False
True