Hi
I have a borehole with multiple standpipe piezometers installed. Water level data has been collected over a six month period and recorded in the monitoring group and monitoring data tables (MONG & MOND).
We're reporting detailed monitoring data, but also want to display the average, min and max water levels for each standpipe on the borehole log.
I can grab the average for one Monitoring Point easily enough with a SQL query, but I'm not sure of the best approach to display multiple water level graphics. Individual discrete graphics would be unaware of each other, and would likely overlap - is there a better log type?
Has anyone approached this problem before?
Thanks
<<Sql(SELECT [MONG].[PointID], [MONG].[ItemKey] _ (SELECT AVG([MOND].[MOND_RDNG]) FROM [MOND] WHERE [MOND].[ItemKey] = [MONG].[ItemKey] AND [MOND].[PointID] = <<CurrSetKey>>) as avg_reading _ FROM [MONG] _ )>>