Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
i want to build any groups with the Avarage as limit from Group und Avarage +1 as Start for the next Group.
I start with 0 and go with 100 Steps.
For Example:
Values:
1
2
9
5
50
55
66
88
99
100
The AVG from my Example is 42
That means my first Group Start by 1 and End by 42.
The next Group must then be calculated as follows:
Avg(Values from (42+1) + 100)
...
Do you have any idea?
Thanks!!!
You can have a dimension with two values (Group 1 and Group 2) and then do
if(Group='Group 1', avg(if(Value<=$(=avg(Value)),Value)), avg(if(Value>$(=avg(Value)),Value)))