How should I increase the speed and performance of dashboard

I have data that have 54 Lakhs monthly record and I have uploaded the data in spice for last 16 months.
I have created a dashboard that consists of pie chart and and table.
In pie chart I am using various calculated fields and formulae’s and ifelse statement.
I am facing the issue when I am selecting more than 3 month in the month filter. I am getting the error [‘Visual taking too long to load’]. I can’t reduce the size of the data as the table in the dashboard is using that complete data.

Please suggest some solution so that the speed of the dashboard is increased.

Hi @Moheed - Welcome to the community.
Moving some of the calculations to the data prep stage instead of performing it during the analysis will help improve the performance. This blog provides a lot of ideas on best practices to improve query performance on calculated fields (including complex if else statements).
If after following the recommendations in the above blog, you still face performance issues, I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!