RangeAvg as KPI per date

[c_latham]

Hi All,

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.

Departure	Visit Key	MPH
Totals		26.76
26/01/2020	11218	30.72
26/01/2020	25352	22.81

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!

[lironbaram]

hi 

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