Line Chart - plot every result without aggregation
It seems like it should be simple. I must be missing something.
I want to plot every result over time so i can show which ones fall out of bounds of the upper and lower control limits.
It works if I show it in a table even when hiding the unique id. However, fast change to the line chart still averages over results that occurred at the same time.
It's definitely averaging. No values are being ignored.
I have an out of bounds value that was not rendering in the 12:01 time slot.I had no values that matched what was being displayed. When I toggled to a straight table, I could see the 5 values separately from 12:01. It was then clear they were being averaged as one in the line chart (even though transaction id is a secondary dimension).
I'll try the scatter, but the request is to show a trending line chart over time with upper and lower control limits to identify the outliers.
I was able to correct the issue by moving the UCL, LCL and Median to reference lines. This allowed the IDs to plot individually. It was necessary to set them as separate expressions. That was throwing everything off.
