ESdat Forums
»
Forums
»
ESdat
»
Filtering in Data View - filter within filter?
Rank: Member
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' )
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 327 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
|
|
|
|
Rank: Member
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!
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 327 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
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Filtering in Data View - filter within filter?
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.