I did the below changes and created a group with below fields(Week,Year,WeekName and MonthName) and I am able to see some what better performance than before. But not very good though! So if you can give any other suggestion which can improve the performance please keep me updated.
Week(date) as Week,
Year(date) as Year,
WeekName(date) as WeekName,
MonthName(date) as MonthName;
DATE(StartDate+IterNo()-1) AS date
Can you please give some other suggestion to improve the performance. For example, I am using the below 'IF Statement' in one of the expression of the pivot table. Can tell the required changes in the script or else can you tell me the Set Analysis with which I can improve the performance please
SUM(IF(ImplStart<=date AND ImplEnd>=date,1))