Hi, I need some help in how to extract information from a data set for a report I am writing.
I have a data set of 156 members of an organisation. Per person it contains Attributes like $Age_2020, $Gender etc. Some of them (like $Age_2020) are numeric, and hence want to write about their minimums, maximums and averages.
Say I want to write a sentence like “The age of the members is between 37 and 95 years”, but refer to the data to produce the numbers. Assume my member notes are children of a note “MemberLIst”, and the numeric attribute I want to refer to is in $Age_2020.
How could I extract the numbers? I tried asking for the minimum / maximum of the list of notes that are descendants of the main note. With the help of aTbRef I tried to piece something together:
^value(min(list(descendants, "MemberList")))^ and ^value(max(list(descendants, "MemberList"))^
but that would not work. Obviously, what is missing is reference to the Attribute $Age_2020 - but where would I put that in?
Any help gratefully accepted! (And while you’re at it: my next wish is to find out the average age, using the same variable…)