To Calculate maximum value from 5 different field related to some customer id.

[#1]

Hello everyone,

I want to pick the maximum values among different fields related to customer Id

My Table is in the form of:

CaseId     OpenToAssignTime     AssignToDevelopment     DevelopmentToTest     TestToResolve

1                    2                                   3                              1.5                              1

2                    2.5                                 3.5                              2                               2.5

3                    1.2                                   1.6                              1.7                         3

so for each caseId i need to calculate the maximum value with field name associated among above time fields.

thanks and Regards.

[#2]

Hi Nupur

here is an exemple

best regards

Chris

[Anonymous]

LOAD * inline

[

CaseId  ,   OpenToAssignTime  ,   AssignToDevelopment  ,   DevelopmentToTest   ,  TestToResolve

1    ,                2      ,                             3       ,                       1.5 ,                             1

2       ,             2.5      ,                           3.5      ,                        2     ,                          2.5

3        ,            1.2         ,                          1.6   ,                           1.7    ,                     3

];

CrossTable(task,value)

load

*

resident abc;

drop table abc;

then craete a straight table add CaseId as dimension.

then use expression   =Aggr(max(value),CaseId)