I have a dashboard with multiple charts and tables, but there is one particular chart that is constantly "reloading". By that I mean it shows an hour glass and a very slow moving progress bar.
What I don't understand is why. This table is not especially complex. It has three simple expressions - the first two are summing amount fields, and the third is to calculate the percentage (compare first amount to second amount). For example:
Expression 1: Sum (Amount_A)
Expression 2: Sum (Amount_B)
Expression 3: "Amount_A"/"Amount_B"
The expressions work, the table calculates correctly, but I don't understand why this particular object is calculating so slowly.