Fish Build Date Metrics

[hahoyt]

Hi Guys,
In the Fish Table in Loki, there is a BUILD_TIMESTAMP field that is automatically generated with the full date and a timestamp every time a fish is built in Loki. It's nice for me to do metrics on this timestamp, example, how many fish were build in each month of 2023, so I can gauge my workload. Eric pulled a report directly from Loki for me so that I could do this very thing in April. At the time, he set up a table "FISH_INVENTORY_V" so that an R script could be written to do this in the future.

Can you all create this option for me to run? I'd only really need it maybe once a year but it would be nice to be able to create and archive those metrics each year.

This is what Eric had in the email and an example of querying by year sampled:

**"In R you can set up your SQL to query all columns and filter by any of the columns. This example filters by year sampled:

SELECT
*
FROM
FISH_INVENTORY_V
WHERE
YEAR_SAMPLED >= 2020;

Or query any subset of columns if you don’t need them all:

SELECT
SAMPLE_COUNT
, COMMON_NAME
-- , COLLECTION_TYPE
-- , COLLECTION_ID
, SILLY_CODE
-- , REGION_CODE
-- , QUADRANT
, LOCATION_CODE
, YEAR_SAMPLED
, SAMPLE_DATE
, BUILD_TIMESTAMP
FROM
FISH_INVENTORY_V
WHERE
COMMON_NAME = 'Moose';

Just omit the column or comment it out with a double dash --."**

Thanks,
Heather