Hello all,
I need your help in achieving this requirement ,they want to show the current and previous audit score location wise ,
which I am able to do that ,so the extension of this requirement is when end user click on current score or previous score then he should able to see break up in different quality wise ...what I mean is
OVERALL_SCR = QUALITY_GOV, SAMPLING,LAB_ANALYSIS, FAIL_MGMT, SUPP_MGMT, RM_SPEC,MAT_MGMT, LAB_INSTR_MGMT
All these fields are predefined fields ,In SCRIPT level what i try to do is
AuditScore:
LOAD MANDT,
WERKS as WERK,
date(ADATE,'MM/DD/YYYY') AS ADATE,
QUARTER,
OVERALL_SCR,
QUALITY_GOV,
SAMPLING,
LAB_ANALYSIS,
FAIL_MGMT,
SUPP_MGMT,
RM_SPEC,
MAT_MGMT,
LAB_INSTR_MGMT
FROM
(qvd);
table:
CrossTable(quality,values,1)
LOAD QUARTER, //(i just blindly took this quater field so that i can have association with top table)
QUALITY_GOV,
SAMPLING,
LAB_ANALYSIS, //i am trying to group all these 8 fields in to one filed using cross table which i am success in doing that
FAIL_MGMT,
SUPP_MGMT,
RM_SPEC,
MAT_MGMT,
LAB_INSTR_MGMT
Resident AuditScore;
finally i want to show these two fields as shown in the last slide
RESULT :
qualityfield values
Expression :
current score
FirstSortedValue(OVERALL_SCR,-ADATE)
pervious score
FirstSortedValue(OVERALL_SCR,-ADATE,2)
please find the attachment and the raw data aswell
