This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am attempting to use what I think needs to be RangeAvg.
Data looks like the following in a table and the total is correct.
However when I do the following in a KPI to try and replicate the total I get 19.29 :
Rangeavg(count([Visit Key])/(round( (max(t_put) - min(t_put) ) / (1/24), .01)))
Do I need to use Aggr as well?
Thanks in advance!
in general range function are useful in charts and table
in KPI assuming you want to get the average of the rows you should use aggr with simple avg