RangeAvg as KPI per date

c_latham — Sat, 16 Nov 2024 03:17:28 GMT

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!

Re: RangeAvg as KPI per date

lironbaram — Wed, 12 Feb 2020 14:37:06 GMT

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