Logic Help aggregation

[abhaysingh]

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

[girirajsinh]

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"

[petter]

E=15 and F=40

[abhaysingh]

can you provide sample pls?

[petter]

Can you provide more context please?

[girirajsinh]

[MK_QSL]

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.

[abhaysingh]

can i achieve it in front end?

[petter]

Yes of course: