Perspective XY chart, Target Zone

Ignition
,
1

I am trying to create an XY table that has a color zone for "good" parts, like this one:
image
I found an example from Ignitions user manual, but that example uses values that are within the dataSources prop.

I was hoping that there would be a different way to set this zone, because I am using a query to populate the values under dataSources.

Any help would be appreciated.

2

Generate the upper and lower control limits in your SQL.

SELECT 
    t_stamp, 
    count, 
    150 AS upperLimit,
    125 AS lowerLimit
FROM ...

If you fill the areas of the limit curves, set the upper to your color band and set the lower to white and get the column order right you should be able to get what you want.