search

biigle / reports

:m: BIIGLE module to generate reports for projects and volumes
GNU General Public License v3.0
1 stars 2 forks source link

Aggregate by label and image in area report #76

Open mzur opened 3 years ago

mzur commented 3 years ago

Add an option for the abundance report to report the abundance per m² per label for each image instead of the total count.

Another option could be to report the total area of annotations per label for each image. Check first if this couldn't be done with the existing area report.

mzur commented 3 years ago

With the area report, the following is possible (in LibreOffice Calc):

  1. Delete the first row
  2. Select the column of interest (e.g. annotation_area_sqpx or annotation_area_sqm)
  3. Select "Data" -> "Text to Columns..." and just click OK to convert the column from text to numbers
  4. Select "Data" -> "Subtotals..."
  5. In "1st Group", select "Group by: image_id"
  6. In "2nd Group", select "Group by: label_ids" and select "Calculate subtotals for:" the column of interest (e.g. annotation_area_sqpx or annotation_area_sqm)
  7. Click OK

Now you get the sum of the annotation area per label per image. Maybe this is enough and we don't need another report.

mzur commented 3 years ago

The Excel/Calc workaround works for now. When there is time, we could still add an option for the area report to aggregate the rows by label or by label and image.