It seems that you have many worksheets in dashboard 3. To fine tune the performance, I suggest you to simplify the views. Re-check if you need to do calculation on tableau. Also I would move some of the worksheets to another view.
Seems all these worksheet are needed in this dashboard 3.
I am looking at why the query execution takes long time.
FiscalWeek calculation looks very ugly (translates in huge case statement).
Can you temporarily remove it and see if situation improves?
Yes, we have identified from the logs that Calculation_1750406104758570 is the problem.
We used the this calculation because the date is actually stored in string format in database. there is no better way of do this.
once we change the storage format of the date and remove the calculation, it is significantly better