Problems with Range AVG

heiko_schmidt — Sat, 16 Nov 2024 03:23:59 GMT

Hello everybody, I am facing some problems with Rangeavg sheet function.(or maybe there is another way to achive the desired result)

To explain my problem i put together some example Data.

my Real Data has more dimensions to take care of.

load * inline
[
Date,Value
1,2
2,5
3,8
4,10
5,1
6,5
7,8
8,5
];

In a straight table i use Sum({<Date={">3"}>*<Date={"<=7"}>}Value) to only display and calculate the values where date is greater than 3 and less or equal to 7.

so the result is a table like that:

Date Sum

TOTAL 23

4 10

5 1

6 5

7 8

Now what i need is a third column with the average of this range and the result should look like this:

Date Sum RangeAVG

TOTAL 24

4 10 6

5 1 6

6 5 6

7 8 6

Any suggestions ?

Best regads

Heiko

Re: Problems with Range AVG

sunny_talwar — Fri, 31 Jan 2020 12:34:47 GMT

Try this

Sum(TOTAL {<Date = {">3<=7"}>} Value)/ Count(DISTINCT TOTAL {<Date = {">3<=7"}>} Date)

topic Problems with Range AVG in App Development

Problems with Range AVG

Re: Problems with Range AVG