Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need a advice from you all.
I have a created a logic for KPI ,values are displaying correct but unfortunately sheets has taking very long time to respond .??
Can any one tell me how to deal with this ?
Kind Regards
Manu
May be too many actions and Sheets are created in the sheet?
there is no triger in it ...
I am using following KPI .....
=num(
(count({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'N'},Flag ={1}>}distinct if(Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date<=Year_MaxDate, Equipment_Id))
+count({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'Y'},Flag ={1}>}distinct if(Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date>=Year_MaxDate, Equipment_Id)))
Any way to opttimise it
??
KInd Regards
MANU
With this, I don't think so why loading page takes time. But, Still we can write 3 Methods more like?
Method-(i)
num(count({<Equipment_isSMA_Upgrade_Eligible={1},
Temp_isEquipmentNoContract={0},
Is_Deleted={'N'},Flag ={1},
Mod_EquipmentStartDate = {"=Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date<=Year_MaxDate"}>+
<Mod_EquipmentStartDate = {"=Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date>=Year_MaxDate"}>} DISTINCT Equipment_Id))
Method-(ii)
num(
(count({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'N'},Flag ={1}, Mod_EquipmentStartDate = {"=Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date<=Year_MaxDate"}>}distinct Equipment_Id)
+count({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'Y'},Flag ={1}, Mod_EquipmentStartDate = {"=Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date>=Year_MaxDate"}>}distinct Equipment_Id))
Method-(iii)
num(
(count({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'N'},Flag ={1}>}distinct
if((Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date<=Year_MaxDate) and
(Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date>=Year_MaxDate), Equipment_Id)))
Hi Manu,
Is this the calculation causing performance issue? Can you try deleting the object and check to confirm whether the issue is because of the kpi?
Hi Siva,
Yes this is because of Kpi.I have already tried by deleting object