Hi Jono,

As you have already identified, the ChemCode that the analyte is reported as needs to be the same as that for the Action Level in the Environmental Standard.  You can check the ChemCode in the data in the Chem Table: click on the Result Cell and click “Result Details & Comments” (on the right). The ChemCode for the result is shown, make a note of this ChemCode.

The Matrix Types will also need to be consistent.

If there is no overlap between the data and an environmental standard then the environmental standard won't be available for that data, which is what you are seeing.

Regards,

Warwick

Hi Jono,

Yes, are you able to describe the steps I can take to replicate the issue.

Can you provide:

• one Lab Report Number that has the relevant data, or a URL ideally.
• indicate the ChemName that you are hoping to see an Action Level for but aren't (a screenshot is ideal if you can), and
• which Environmental Standard you are using.

Thanks,

Warwick

Edited by user Wednesday, March 4, 2020 4:29:29 PM(UTC)  | Reason: Not specified

Hi Jono,

Further to my reply, I've attached a image to help describe what I tried to explain in the first reply if you want to go through the investigation process yourself.

ChemCodes.png (39kb) downloaded 4 time(s).

1. Click on the Result you dont have a Action Level for, but want one for.

2. Click Results & Details

3. Get the ChemCode

You should then make sure you have an Action Level for that ChemCode (and also that it's for soil/water etc.. as appropriate).

Also, if you have any unit conversion problems verify they don't relate to that ChemName.

Warwick

Edited by user Thursday, March 5, 2020 9:19:05 AM(UTC)  | Reason: Not specified

Hi Jono,

Can you also check the Matrix specified for the sample & also the Matrix specified for the Environmental Standard, especially if it's a custom environmental standard.

Warwick

Hi Jono,

In the lab report you mentioned (EB1921509) the samples have a matrix of"Water", not Trade Waste.

If you are seeing something different when you checked can you send screenshots?

Thanks,

Warwick

Hi Warwick,

I continue to have problems with a particular environmental standard not showing all the action levels. Specifically this is for 'Sewer Admission Limits - Redland Shire Council Policy'.  Only some inorganics and metal action levels appear, and all chem names and codes are as per the lab results, and matrix types are all the same (Trade Waste), as per lab report too.

Not sure if this link is useful but would very much appreciate you taking a look.

https://online.ESdat.net/DataView/ChemistryResults?module=chemTable#settingGroupId/276/&filter=%5B%7B%22Field%22%3A%22MatrixType%22,%22Operator%22%3A%22in%22,%22Value%22%3A%5B%22Trade+Waste%22%5D%7D,%7B%22Field%22%3A%22Site.ID%22,%22Operator%22%3A%22in%22,%22Value%22%3A%5B11080,11058%5D%7D,%7B%22Field%22%3A%22FieldOrLabData%22,%22Operator%22%3A%22eq%22,%22Value%22%3A%22Both%22%7D,%7B%22Field%22%3A%22SampledDate%22,%22Operator%22%3A%22bw%22,%22Value%22%3A%222020-02-01T10%3A00%3A00%22,%22Value2%22%3A%222020-03-17T10%3A00%3A00%22%7D%5D

Thankyou.

Thanks Warwick, that finally resolved the problem! I just changed my units in the Env Standards I uploaded.