Last video in a series of four, demonstrating how to:
- set up a query that uses a previous query as a source (the RAW data),
- generate calculated fields (% difference from a standard),
- send this automatically to an x-y scatterplot (because our QC checks are not always at perfect 14 day intervals, so we have some irregular intervals so a pivot chart is misleading)
- plot % differences on one axis, and flow rate leak checks on a secondary axis
- apply a template combo chart.