R functionality in Queries - additional calculations in queries

SMART Community Forum
1

Hi all,

I was wondering if anyone has experience with the R functionality under Queries. I would like to test some things, but would be nice to have an example of how it actually works.
I am looking into adding some additional calculations to the queries that are not possible with the current set up, before integrating it in Reports.

Maybe someone has another tip/advice. Below the case I am looking into.

The data model lists all unique ID numbers for animals. During each observation in SMART, ID numbers will be added.
A query can pull out how often each ID number has been mentioned in any of the conf models.

image

Etc.
This would be a total of 2 unique IDs sighted, instead of 4 observations for these IDs.

However, a query can’t make a sum of how many unique ID numbers have been recorded in any type of conf models. So not the number of observations, but just a “yes/no” per unique ID number.
At the moment, we pull out the list of all unique IDs with the number of observations behind it. Then manually in Excel we have to calculate how many unique ID numbers this includes.

Does anyone have an idea how to make this easier, either in Reports or with R in the queries?

Kind regards,
Elke

2

In Report, you can add an aggregation, then use COUNT function.

image
image916×600 37.6 KB

Regard

Lili Sadikin

3

Magic!!
Thanks so much. Exactly what I needed!

Do you know if there is any tutorial or documentation on the aggregation functionality?
I would like to add some additional calculations, like adding value of different columns before using count to count the unique IDs.

Kind regards,
Elke