Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I cheacked your attached qvw file(setAnalysisTask.qvw).
In your qvw, two tables does not link.
Could you modify load script? like below
---------------------------------------------
Empp:
LOAD ADDRS,
BIRTH_DATE,
Year(START_DATE) as year,
D_NO,
FIRST_NAME,
LAST_NAME,
SALARY,
SEX,
SSN,
START_DATE,
SUPERSSN
FROM
You need to get the year from Empp table.
Expression:
Avg(Aggr(SUM(SALARY),year))
View solution in original post
Use
Avg(Aggr(SUM(Salary),Year))
Hi manish,
still it is not working ......what is the use of Aggr function ...what it does
Provide me some more data or your sample apps
Check the attachment.
Thanks,AS
Please check with the attachment !!!!!!!!
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)
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
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
Use below as Calculated Dimension
=Aggr(Year(Date(Floor(Timestamp#(START_DATE)))),START_DATE)
AVG(SALARY)
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
