Concatenation vs link tables

[anagharao]

Hi Everyone

I would like to know which one of the below leads to better utilization of RAM and how each affects the performance of the dashboard.

Option 1: Concatenation

SUM({<Scenario={'Actual'}>} Amount)  + SUM({<Scenario={'Budget'}>} Amount)

Option 2:  Link table

SUM(Actual) + Sum(Budget)

[MohasinKhan]

Hi,

In my experience, either of those do not make much of a difference, it is best to use what you are comfortable with (the simpler the better)

The type of charts you use, cause lagging and delays on the dashboard page.

If you use any of the default charts, you should be ok. Try and avoid using custom objects.

Hope this helps.

[Almen]

What about SUM({<Scenario={'Actual', 'Budget'}>} Amount)? Plain SUM is generally not problematic in terms of loadspeed.