Community Forum     Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
jonathanschmidt  
#1 Posted : Tuesday, March 16, 2021 11:42:05 AM(UTC)
jonathanschmidt
Rank: Newbie

Reputation:

Groups: Registered
Posts: 6

Is it possible to add columns to the exceedances in data view?  I want to add the comments associated with a chem code for an env standard so that I can then filter based on the comments.  The plan is to create a custom env standard and in the comments of each chem code to give that standard a "low reliability", "modertae reliability" etc based on whether the standard is reliable or not.  So when I create an exceedance report I can filter for those standards that are highly reliable based on the comment.

Nick Tumney  
#2 Posted : Tuesday, March 16, 2021 1:32:55 PM(UTC)
Nick T
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 234
Australia

Was thanked: 20 time(s) in 20 post(s)

Hi Jono,

Just to confirm, you're refering to this report?

Exceed.PNG (130kb) downloaded 1 time(s).

Nick

jonathanschmidt  
#3 Posted : Tuesday, March 16, 2021 4:50:24 PM(UTC)
jonathanschmidt
Rank: Newbie

Reputation:

Groups: Registered
Posts: 6

Yes that's what I am referring to Nick. I want to add a column to that report which has the comments associated with the chem code/env standard so I can filter those comments based on the reliability of the standard. I got the idea when I saw this https://www.ESdat.net/ES...erver_Help/clip4197.png. In that image you can see the comments with "low reliability" etc.
jonathanschmidt  
#4 Posted : Tuesday, March 16, 2021 4:53:35 PM(UTC)
jonathanschmidt
Rank: Newbie

Reputation:

Groups: Registered
Posts: 6

Link I provided seems to be broken so here is the image

Nick Tumney  
#5 Posted : Wednesday, March 17, 2021 8:06:51 AM(UTC)
Nick T
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 234
Australia

Was thanked: 20 time(s) in 20 post(s)

Hi Jono,

Unfortunately adding that column is not something that can be done quickly, as the report is used in several locations within ESdat, and also linked to Lab Upload notifications.

However, we do see the merit in showing the comments and it is something we will look at implementing in a future update.

To address your immediate need, you could achieve a similar outcome by having three separate Environmental Standards with the reliability included in the name.

For example, instead of having just "ANZG (2018) Freshwater 95% toxicant DGVs" (which I would retain), you could also create additional standards called "ANZG (2018) Freshwater 95% toxicant DGVs - low reliability", "ANZG (2018) Freshwater 95% toxicant DGVs - moderate reliability", etc...

These standards could include only the relevant reliability values, and would allow you to filter in the Exceedance report the way you want.

It also means that you could use those standards in the Chem Table, allowing you to highlight your results differently based on the reliability if that was something you wanted to do.

I hope this helps.

Cheers,

Nick

jonathanschmidt  
#6 Posted : Wednesday, March 17, 2021 8:39:10 AM(UTC)
jonathanschmidt
Rank: Newbie

Reputation:

Groups: Registered
Posts: 6

Thanks Nick.  It'll be great if this feature gets updated in the future.  What you suggested in creating multiple environmental standards for the various "reliabilities" is what we were planning to do.  Thanks for your comments.

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.