The requirement of our dashboard is to show the data in detail and summary tabs.
The count of data per day is approx. 5 Millions and in the dashboard we are showing the 15 days data.
So , the problem is , we are pulling in all the 5 Millions * 15 Days data in the details tab , due to which the performance of the dashboard is degrading and there is always a lag when we select any filters or move across the tabs.
Can you please provide some solution to tackle this problem ? As how we can optimize the performance.
