Forum Discussion

qLollo's avatar
qLollo
Frequent Visitor
4 years ago
Solved

Visual loading time is taking forever

Hi all, I've been having issues with my report, in particular, with 2 visuals. My dataset is pretty big, i have 40+ tables, each one has god knows how many rows, but that's not the problem, becau...
Need Help
Tips and Tricks
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi qLollo ,

 

After reviewing the formulas you provided, there does not seem to be a complex calculation logic. I think it is indeed a problem caused by loading a data set that is too large.
What is your data source? Is it possible to do some filtering of the data before importing (filtering out the parts that are not relevant to the calculation), which would optimize the speed of loading.


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • qLollo's avatar
    qLollo
    Frequent Visitor
    4 years ago

    Hi v-henryk-mstf ,

    I've been able to reduce the loading time from 10 mins to 2-3mins just by changing the formula, and making it as the IF does firstly the condition with the most amount of rows, so it will not waste time checking a lot of rows, i think it's not possible to reduce the time more than this, since i can't filter the data more or reduce the data set, so i consider this solved.