Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
padmanabhv
Contributor III
Contributor III

Histogram - time series field

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
     
Labels (3)
2 Replies
vinieme12
Champion III
Champion III

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 

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/Conditi...

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
padmanabhv
Contributor III
Contributor III
Author

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.