Suggestion

[#1]

Hi all,

I have a pivot table with the following dimensions and expression:

Dimensions:

• BranchCode
• AccountNumber

Expression:

• Sum(Aggr(FirstSortedValue(EndingBalance,-TrxDate),AccountNumber,BranchCode))
  

My goal here is to get the last Ending Balance of an account and and sum it up base on brach code. Is there another way/expression aside from my current expression that will give me the same result but more optimized because my worry with my current expression is if I have more that 60M worth of data my dashboard will slow down..

Thanks!!!

[its_anandrjs]

Hi,

I suggest no worry because your pivot has few Dimensions and expression so it is not any problem when increase the no of Expression and Dimensions untill it is ok.

HTH

Regards

Anand

[#3]

I replicated this using 4 dimensions with 11M+ worth of data but the chart took approximately 30 seconds to load. so now I'm looking for other way...

Thanks!

[suniljain]

If you are using complex expression in chart it wil take time to display content. so i will suggest to implement calculation in background.

[its_anandrjs]

Hi,

If you are using Dimension and Expression like this for this i suggest to use the variables for expression and use this variables in your chart. Use as much as possible the variables it will decresse the loading time like

vSum = Sum( Yourfield )

vCount = Count( Expressions )

vTotal = Count( Check condition )

like ways other also it will depends on your expression and dimension, use this variables in chart.

HTH

Regards

Anand

[#6]

but everytime I put FirstSortedValue(EndingBalance,-TrxDate) in the script i get an Invalid Expression error.. I already put a Group by clause..