PFA the QVW which contains two pivot tables which are creating performance issues when ever I select multiple months/weeks in the filters. Could someone help me simplifying this.
All of the work in the calculated dimension and then the large expression should be done in the script, using fields as dimensions to label the data correctly. Doing this work in the pivot table itself is creating the huge overhead.
Hey, Please don't forget to add kudos, like or mark as a solution if my reply has helped you at all! 🙂
You need to develop another logic for your datamodel to work just with native dimensions and simple expressions like: sum/count(value). Creating synthetic dimensions with valuelist() and using expressions with multiple nested if-loops respectively pick(match()) is very poorly from a performance point of view.
