Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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