Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (1)
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.