Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have lets say Temperature (field = Temp), that is continuously collected for a bunch of animals every 5 seconds over a period of lets say 10 minutes. Lets assume we have a bunch of such animals.
I am trying to create a histogram of average temperatures for each animal. x axis showing the buckets of average temperature, and the y axis height show how many animals have avg temp in that bucket.
How do I do that ? What formula would I need in the the "bars" section of my histogram.
I am confidant it is some combination of avg() and aggr() possibly ? But I just cannot seem to figure it out.
Thank you !
Animal_number | Time | Temp |
1 | 00:05 | 100 |
1 | 00:10 | 101 |
. | ||
1 | 10:00 | 99 |
2 | 00:05 | 101 |
. | ||
. | ||
x | 10:00 | 99 |
A histogram is a frequency plot, you can just use temp as X-axis and Count(Animal) as measure
if you want to create buckets for temp then use the class() function
I do not want all the temps vs count on my historgram - this will end up showing too much data.
I was hoping to get an average temp (one per animal) and plot that vs count.