Issue need help

[#1]

Hi All,

I want to calculate the year wise average/sum of salary . I used year as dimension and

below expression in Expression:-

Avg(SALARY)

But..even after doing this i am getting same salary row wiese in every year row ...

Year       Salary

2010       32000

2011       32000

please help me in this regards:---

Sarfaraz

[MK_QSL]

Use

Avg(Aggr(SUM(Salary),Year))

[#3]

Hi manish,

still it is not working ......what is the use of Aggr function ...what it does

Sarfaraz

[MK_QSL]

Provide me some more data or your sample apps

[amit_saini]

Check the attachment.

Thanks,
AS

[#6]

Please check with the attachment !!!!!!!!

Sarfaraz

[MK_QSL]

Load * Inline

[

  Emplyee, Year, Salary

  A, 2012, 100

  B, 2012, 150

  C, 2012, 200

  A, 2013, 200

  B, 2013, 250

  C, 2013, 300

  A, 2014, 200

  B, 2014, 300

  C, 2014, 400

];

Create a Straight Table

Dimension

Year

Expression

Avg(Salary)

[#8]

It is working with your example ..straight way you put year number there ......in my case i am taking Year from the field and not working in my case ....request you to please see the above attached file

Hope you will help me

Sarfaraz

[MK_QSL]

Define your

Month and Year in script as below

This should work

Year(Date(Floor(Timestamp#(START_DATE)))) as Year

Month(Date(Floor(Timestamp#(START_DATE)))) as Month

Or

Create a Straight Table

Use below as Calculated Dimension

=Aggr(Year(Date(Floor(Timestamp#(START_DATE)))),START_DATE)

Expression

AVG(SALARY)

[its_anandrjs]

Hi,

In expression try this

Avg( TOTAL SALARY ) 

And see what you get also for 2010 and 2011 what is average value from your side.

Regards

Anand