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