OF Calc: filtering data according to tree species

  • Asked
  • Active
  • Viewed 3464 times
0

Dear Support Team,

when displaying my tree data in calc, I would like to group the data according to species (e.g. to create tree height / diameter relationships per species). However, in data view, I can only filter via the species code.

Is this the only way to filter the data per species? What can I do if I would like to have a text variable with the scientific name of the tree species?

Thank you so much for your help!

1

Accepted answer

Dear wexxo,

Aggregations on row data are not supported in data view of Calc, if you wish to do so, you can download the CSV file and aggregate them in an external software like Excel.

Also, species are imported as code variable and therefore you can only view and filter the code; joining the row data with the scientific name must be done externally. However I understand it could be useful to have it in Calc directly, we'll be thinking a way to achieve that.

Thank you for your input, we'll let you know.

Mino

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Menu

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.