Referring Calculated Dimension in an Expression - Optimization

[#1]

Hi,

I have a straight table that has a column "CompletionStatus" which is a calculated dimension( If (ConditionSatisfied), 'Completed', 'Not Complete')). Now, I have a second column StudentDescription which should populate only when CompletionStatus='Completed'. I tried if(CompletionStatus='Completed', StudentDescription, Null()). But, this does not seem to work, since CompletionStatus is not a field. For now, I am using the expression in CompletionStatus to make the second column StudentDescription work If (ConditionSatisfied), StudentDescription, Null())).

But this is causing performance issues as I have millions of records, and every record has an associated CompletionStatus and StudentDescription.

How can I optimize the expression If (ConditionSatisfied), StudentDescription, Null())). for better performance?

Thanks!

[aarkay29]

• the best approach would be to move the calculation to script if possible.
• Limit the number of rows in the straight table by specifying in the presentation tab.
• or On open sheet make predefined selections such as Current month/year to limit the no.of rows

[sasikanth]

And one more thing is Force user to select any combination of filters so that the no.of records will be reduced .

Ex: Year, Month etc.

1) Create a calculation condition in chart general properties

    GetselectedCount(Year)<0 and GetselectedCount(Month)>0

2) Go to Error Messages and select Condition unfulfilled Then write a message

"Please select at least one Year and Month"  it will be easy for the user