Statistics

Statistics displays an overview of your facility's fish stocks. Using the export button in the top right corner you can export the data to a .xls file based on the selected filters.

General stats

General overview

• Total number of tanks The number of tank positions available in your facility
• Total number of substocks The total number of all live substocks
• Productive fish count The total number of productive fish in the facility

Pie charts

• Fishlines based on the genotype (transgenic, mutant, mixed, wild-type)
• Fish based on age (fry, juvenile, adult, retired)

Bar charts

By default, bar charts are showing monthly statistics for the last 12 months.

• Born fish the number of animals based on the initial counts of substocks with the corresponding date of birth
• Deceased fish the total number of fish reported as "found dead"
• Euthanized fish the total number of fish reported as "euthanized"
• Fish used for experiments the total number of fish used in an experiment, can be further refined by defining the desired experiment in the filter.

To change the bar period or filter for any further specifications, click on the Filter button next to the Productivity, usage, and health heading. Additional details can be defined here.

Custom bar charts

Other count types can be included in the statistics by setting the count types parameter custom stats to True (go to Admin > Codebooks > Count Type). Every count type with custom stats = True will then have its own bar chart in stats (named Custom stats: <count type name>).

Filtering

Bar chart data can be filtered based on any string included in the substock name by adjusting:

• Name contains

For the bar charts, it is further possible to select:

• Fishline - one or multiple fishlines
• Responsible user - one or multiple users who are associated with the corresponding fishline
• Fishline background - one or multiple fishline background(s)
• Modification category - one or multiple categories of the associated genotypes
• Marker gene - one or multiple genes associated with the corresponding transgenic genotypes (e.g. GFP)
• Date of birth - to adjust the period for DOB
• Experiment - one or multiple experiments
• Rooms - rooms based on current substock positions
• Racks - racks based on current substock positions
• Workgroups- one or multiple workgroups, based on the current workgroups associated with substocks
• Owner - one or multiple owners, based on owners associated with substocks (current state)
• Project - one or multiple projects, based on projects associated with substocks (current state)
• Genotypes - one or multiple genotypes
• WT/non-WT switch - to show all data only for WT or only for the modified substocks
• Status - one or multiple statuses that should be displayed

Billing stats

Generating billing statistics is slow so please be patient.

The billing statistics report the number of living fish and used tanks over a given period. The default period is the last whole calendar month; this can be changed in the Filters.

Tank counts (!)

• filtering by room provides only the counts of fish placed in the selected room
• wider tanks are considered single tank
• split or shared tanks are considered single tank
• if a tank is occupied by two substocks owned by different workgroups and billing stats are calculated for the workgroups separately, this tank will be counted twice (once for each of the workgroups)

Tank pricing

The price per day can be set for each tank (for admins only).

1. prepare predefined prices - Admin / Codebooks / Others / Position Price:
   prepare some predefined prices that can be attached to the tanks
2. set default price - Admin / Configuration / defaults.position.price
3. assign prices to tanks - Facility view:
   use scope "Price" to visualize and mode "Price" to edit (you can set a price for both empty and occupied tanks)
   

Billing statistics graph

1. fish count scale
2. used tanks scale
3. legend - clicking on a dataset toggles its visibility

Plans for future versions

• billing based on requests