Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
i have data like below
ID,Value
A,10
B,20
C,30
D,40
F,50
OutpuT required
ID,Value
A,10
B,20
C,30
D,40
F,50
E, Avg(A,B)
F, avg(C,F)
Regards
Abhay
Hi Abhay
You may achieve same in two ways.
1. Use RESIDENT load and create two extra field and use 'if' condition for calculating Average for it.
2. while showing in chart, you may create "Calculated Dimension"
E=15 and F=40
can you provide sample pls?
Can you provide more context please?
Data:
Load * Inline
[
ID,Value
A,10
B,20
C,30
D,40
E,50
];
Load 'F' as ID, Avg(Value) as Value Resident Data Where Match(ID,'A','B');
Load 'G' as ID, Avg(Value) as Value Resident Data Where Match(ID,'C','D');
//Change value of ID according to your need.
can i achieve it in front end?
Yes of course: