RangeAvg as KPI per date

c_latham · ‎2020-02-12

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.

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 · ‎2020-02-12

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