Chart doesnt load because of quantity of data and time that takes

[Nemo1]

Hello everyone, 

so I created a container with two huge list with lots of formulas, and a button, when you click it, you have the option to chose the list u want to see. the thing is, when i click it, takes ages to load and it ends up giving me an error. 

how could i solve this?

thanks

[ali_hijazi · Accepted solution]

Hello 
there are several factors that affect on the performance of your expressions but mainly it is the schema that has major effect.

if you have a measure for example that has "components" from several fact tables in your schema, then here you might need to maybe join those fact tables into one and do part of the calculation in the script:
ex:
sum(field1, field2)
field1 is in Table1, and field2 is in Table2
then join Table1 and Table2 into a table named FACT for example
then in this new table you create a new field which is field1+field2 as field3

then your expression would be sum(field3)