Correct usage of aggr instead of range{some}

Thu, 25 May 2017 08:10:05 GMT

Hello all, some strange thing for me, when i using rangeavg and avg(aggr(..)..), i get two different results.

I know about i get wrong usage, i am new and didn't know how to convert from rangeavg syntax to aggr.

hereis my case,

i get some table with

and soone

i need to get super average value of statuses for all dates, with rangeavg i get desired result in @table with dimension:

floor(

rangeavg(

above(

count({<[status]={'closed'}>} [number]),0, rowno()

)

but when i need to get #1 KPI and try to convert to avg(aggr i dont get desired result =(..

floor(

avg(

aggr(NODISTINCT

count({<[status]={'closed'}>} [number])

,[date]

)

where did i get wrong ?

topic Correct usage of aggr instead of range{some} in App Development