What are the causes of poor chart performance?

[#1]

Hi

can any body tell me what are tha major causes for poor performance of chart

[chiru_thota]

(1)  Using expressions with Distinct key words

(2)  Too many dimensions and expressions

(3)  Having dimensions with lowest granularity Ex: Account ID,transaction

(4) using two much set analysis (nested if')  and Conditional hide/show

[jagan · Accepted solution]

Hi,

Performance issues in charts is because of

- Huge Calculations in front end instead of doing in script

- Use of Distinct, IF() and Aggr()

- Showing huge data for example all Transactions data, also issues especially araises in Table boxes and Straight and Pivot tables.

- Inadequate RAM and  system resources

- Huge file size

etc.

Regards,

Jagan.

[#4]

Add Minicharts to that. If the minichart has a complex expression and spans a number of years/months, then that causes a significant performance hit.