Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
paige_spurgeon  
#1 Posted : Tuesday, February 28, 2023 1:05:46 AM(UTC)
paige_spurgeon
Rank: Member

Reputation:

Groups: Registered
Posts: 20

Thanks: 2 times

We used to be able to filter more specifically using SQL and brackets in ESdat desktop - wondering if its possible to achieve the same in this new version?  Specifically trying to see Metals, Field, Inorganics (but only filtered metals).  If i apply the filter for T or F, this applies to all three Chem Groups.   This is an example of how the old filter would appear: (Chem_Group =  'Metals'  And Total_or_Filtered =  'F' ) Or Chem_Group In( 'Inorganics' ,  'Field' )

Nick Support  
#2 Posted : Tuesday, February 28, 2023 4:06:12 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

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

Hi Paige,

You can build complex filters using the "Data Explorer" tool which was introduced in v4.4.

You can access this in "Data Views / Data Explorer".

These views also allow list exports to Excel with a live link back to ESdat, meaning that you can create your own tables and reports (such as graphs) in Excel and then update them when new data is added to ESdat.

Thanks,

Nick

paige_spurgeon  
#3 Posted : Tuesday, February 28, 2023 4:39:10 AM(UTC)
paige_spurgeon
Rank: Member

Reputation:

Groups: Registered
Posts: 20

Thanks: 2 times

Thanks Nick! This seems like a good tool for investigating specific datasets (similar to the DMM View & Edit section).  I don't think we will be able to use it for our summary tables in the way I was hoping though - the excel export option in Data Explorer doesnt have the option to apply a table layout or standards the same way that Data View does.  Thanks anyways!

Nick Support  
#4 Posted : Tuesday, February 28, 2023 5:53:06 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

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

Hi Paige,

You just need to select the Chem Table option and it will show your filtered data as a chem table (assuming you are on one of the chemistry views -soil, water, etc).

chemtabdx.png (49kb) downloaded 0 time(s).

Thanks,

Nick

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.