Hi every one,
I have different table
TableName:
AQWA_ID
CATEGORY_ID
CATEGORY_NAME
CAUSE
CONVERTED_TO_ISSUE (1,0 if 1 it is converted into issue if Zero not converted into issues)
COPY
CREATED_ACTION
CREATED_AT
CREATED_BY
DETECTABILITY
FROM_IMPACT
FROM_WAIT
RISK_ID
IMPACT
ISSUE_EID
LEVEL_SPECIFIC
MITIGATION_STRATEGY
PROBABILITY
QTL
RE_OPEN
SCORE (Low Score, Median Score, High Score)
SERVICE_ID
SERVICE_NAME
STATUS
STATUS_NAME (Values-> Open, Closed, Reopen)
SUPPLIER_NAME
TRIAL_ID
RISK_TYPE (Values--> RISK, ISSUE)
Here i need to calculate how many risk_Ids are assigned to STATUS_NAME wise and SERVICE_NAME, QTL
How many risks are converted into issues CONVERTED_TO_ISSUE ,
Count of risks by CATEGORY_NAME
actually i have all these aclculation in frontend side i am facing performance issues so i need to calculate all these calculation in scripting side please guide e here all Expertise
Very thanks for being helping me..
I need to do all these calculation in scripting side how can i do please guide here
