We are trying to calculate values of certain KPIs at script side and storing those values into Qvd but we are facing challenge in that, need help on that.
Below is the script which we have written and with that we are not getting appropriate output:
LET rowText = NoOfRows('Threshold');
for i=1 to $(rowText) // loop through every row
let vMETRICID = Peek('METRICID',$(i),'Threshold'); Let vDOMAINID = Peek('DOMAINID',$(i),'Threshold');
Let vBrkFixReslDen='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResolutionTargetBreachFlag={0,1},isInternal={1},ToolType={1}>}Task)'; Let vBrkFixReslNum='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResolutionTargetBreachFlag={0},isInternal={1},ToolType={1}>}Task)';
Set vBrkFixRespDen='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResponseTargetBreachFlag={0,1},ToolType={1}>}IncidentID)'; Set vBrkFixRespNum='Count({<DOMAINID={''$(vDOMAINID)''},ExcludeFromSLAFlag={0},SLA_ResponseTargetBreachFlag={0},ToolType={1}>}IncidentID)';
Let SLA_M1 = '=Pick(match($(vMETRICID),51,61), Num($(vBrkFixReslNum)/$(vBrkFixReslDen),''##0.00%''), Num($(vBrkFixRespNum)/$(vBrkFixRespDen),''######.0'')
)';
SLAValues: Load '$(vMETRICID)' as Metid, '$(vDOMAINID)' as Domid, '$(SLA_M1)' as SLAMI, '$(vMETRICID)'&'|'&'$(vDOMAINID)' AS SLAID AutoGenerate 1;
LET vQVDexists = if(FileSize('lib://QVD_DATA/SLAValues.qvd') > 0, 1, 0);
IF vQVDexists = 0 THEN Store SLAValues into [lib://QVD_DATA/SLAValues.qvd](qvd); Else Concatenate(SLAValues) Load * FROM [lib://QVD_DATA/SLAValues.qvd] (qvd) where Not Exists(SLAID);
Store SLAValues into [lib://QVD_DATA/SLAValues.qvd](qvd); End if; Drop table SLAValues; Next
in the SLAMI column of SLAValues table instead of getting the result value we are getting a string with formula in it like:
but instead of formula we want to get the calculated value in this column or else if we can get the value in the chart/table when we select this column that should also work.
