RE:How to Do Productivity?

[Chanty4u]

hi all,

i have fields lik

t_id	t_desc	t_hrs
47	Onst/Offshr	5
47	Test - Exe - ST 47  Test-Des-ST	20
47	Onst/Offshre	5
47	Non-RT	6

1)where  ST  and RT    are the string values.

and in ST  design  is there and too RT also hvng design

i need to caluclate

Effort spent in days?     how to do this?

[sunny_talwar]

Not sure I understand what your expected output is

[Anonymous]

Effort for what? Designing? Execution?

If it is for designing then try like this:

=sum({<t_desc={'*des*'}>} t_hrs)/24  which would give you number of days for designing

[Peter_Cammaert]

You didn't specify over which dimensions this calculation should be performed, so this will probably do:

=Sum(t_hrs)/24

If not, please specify which dimensions you want to use (in for example a straight table) or post a screenshot of the desired object. You can simulate your object in Excel.

Best,

Peter

[Chanty4u]

yes i want to caluculate..

for design

[Anonymous]

Try these expression:

I am assuming mentioned format by you

SIT:

=sum({<t_desc={'*design*SIT'}>} t_hrs)/24

RT:

=sum({<t_desc={'*design*RT'}>} t_hrs)/24

[Peter_Cammaert · Accepted solution]

I'm sincerely sorry, but I do not understand your requirement. If you want calculations to be done in a pivot table (as shown in your screenshot), then the simple Sum(t_hrs)/24 will do. It's only a matter of choosing/generating the correct dimensions.

Alterantively, you can create two expressions (call them 'ST' and 'RT') and embed the required process in set analysis as others have shown before:

= Sum({<t_descr = {'Test-Des-ST'}>} t_hrs)/24

and

= Sum({<t_descr = {'Test-Des-RT'}>} t_hrs)/24

Note: these expression will be applied on all rows and won't allow changing process phases via set analysis (as your metrics dimension seems to imply). You'll have to use a nested IF expression instead.

Best,

Peter

[Chanty4u]

sry peter...

as that is testting metrics in Text object...