Count multiple tree diameters

This kind of behavior is easiest achieved with through the Saiku analysis rather than with calculated variables (unless you want somehow to see this data while you are collecting the data through Collect Mobile, is that the case?? )

First of all you need to have a multiple entity (tree) with an attribute (diameter) which could be a number or a code attribute (with numbers).

After you collect the data, import it back from Collect Mobile into Collect (Data Manager), then you can access the Saiku Analysis interface (directly from Collect, and visualize the data there (by gragging and dropping the Diameter dimension and Plot Count measure.

Does this answer your question?

Hi Thomas,
If you want to have a list of counters per diameter class, you will have to:
- create a code list called diameter_class with the values you were saying (4cm,6cm,8cm till 80cm) - create a calculated attribute of type Code inside the tree entity called tree_diam_class, using diameter_class as code list; the calculated value expressions will be:
a) constant value=NA - Apply when=idm:blank(tree_diam)
a) constant value=4 - Apply when=tree_diam <= 4
b) constant value=6 - Apply when=tree_diam <= 6
c) constant value=8 - Apply when=tree_diam <= 8
d) constant value=80 - Apply when=tree_diam <= 80
e) constant value=80_plus - Apply when=tree_diam > 80
- define a multiple entity with table layout at the same level of the tree entity and call it tree_diam_class_counts or whatever you want
- define a key code attribute inside this entity and use the diameter_class as code list and call it diameter_class - define a calculated number attribute and call it tree_sum or similar - use this expression in the calculated value expression section: count(parent()/tree[diameter_class = $this/parent()/diameter_class])
Basically, the expression parent()/tree will "access" the list of trees from your context node (the calculated attribute); when you put an expression inside square brackets "[]" you are "filtering" the target entities by some condition (in this case diameter_class = $this/parent()/diameter_class that means the diameter class of the tree must be equal to the diameter class in the entity where "this" attribute is defined).

I hope it's clear enough, try to experiment with it a bit and let us know if you need more support from our side.

Many thanks,
Open Foris Team