Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can we minus the dates .ie in below excel i want to do minus like [Current-Date -Joining-Date] then average .
Requirement:
i want to know in how many days an employee is moving to higher position like [L1-L2]
Output :average days took to go to L1-L2 Position
Plz Help me
Load the data from your excel file:
DATA:
LOAD [Emp-Id],
[Joining-Date],
Position,
[Current-Date],
[Current-Positin]
FROM
[Analysis.xlsx]
(ooxml, embedded labels, table is Sheet1);
Then create a text box with this expression to calculate the average days
=Avg( [Current-Date]-[Joining-Date] )
edit: simplified the expression
thanku Swuehi.
in text box i want like this:
how many days it required for changing Designation like L1-L2 only in excel i have L2-L3 so on but i want only for L1-L2
Hi,
you can use some thing like this,
=if(GetFieldSelections([Emp-Id]),[Joining-Date] & ' '& [Current-Date] & ' ' & Count([Current-Date]-[Joining-Date]) & ' Days Difference' & Position & ' '
& [Current-Positin] & ' ' ,
'Select EMPID')
Hope this helps,
Thanks,
hirish
Ok, I think I understand now better.
Just use above expression in a text box, then select L1 in Joining Position and L2 in Current Position list boxes?
If you want a chart to show all upgrades, maybe create a straight table chart with two dimensions:
[Position]
=if(Mid([Current-Positin],2,1)>Mid([Position],2,1),[Current-Positin])
Enable 'Suppress when value is NULL' for second dimension on dimension tab.
Use as expression again:
=Avg( [Current-Date]-[Joining-Date] )
If you only want to show a fixed KPI for L1 to L2 upgrades in a text box:
=Avg({<[Current-Positin] = {"L2*"}, Position = {"L1*"}>} [Current-Date]-[Joining-Date] )