Any help for the below issue would be greatly appreciated
I am charting strength per batch
each Batch could have been made a with different strains. We have 4 categories of strain but could have 2 strains in one category
my chart shows strength for each batch sorted by autonumber(Strain)
I am wanting to show historical mean, SD, UCL and LCL Values on the chart.
I have a separate imported table with the historical data, Year, Category, Mean, SD values
I can manage to display the Mean and SD etc for the Categogories.
This is my Expression to display the Mean Historical Value
however, we may need to display different Mean,SD for a any new strains coming in until we can incorporate the data into the correct Category.
I can achieve this with one new strain, but not with 2 new strains. (Example, just loading Strain 1 or Strain 2 gives the correct Mean displayed on the chart, loading both together causes the chart to ignore both sets of data for Strain 1 and Strain 2)