Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi...
Can any one suggest alternative to 'if' statement. so that my performance of my dash board increases. i was told it because of 'if' statement my dash board performance is not good.
Hi
You have 2 options:
1) Create if statement in the backend Script and than use that field in your Charts Dashboard.
2) Use Set Analysis. It is performance wise faster.
Regards
Av7eN
I guess i cant use IF statement in the back end script as it might expose functionality to user. i need to publish my dashboard on EG server.
I can try out Set Analysis. Can you please provide a compassion code for IF and SET analysis.
Hi,
Check this
Regards
ASHFAQ
eg.
IF STATEMENT:
Count(Distinct if(Product='Butter' or Product='Milk',Tokens)
SET ANALYSIS:
In Set Analysis you can write Multiple Statements.........
=count({<FLAG={'OPEN'},Status-={'Not Delivered'},[Common Date]={">=$(=Date(vminDate),'DD/MM/YYYY'))<=$(=Date(vMaxDate1,'DD/MM/YYYY'))"},[Common Month]=,[Common Year]=>}DISTINCT Token)
Regards
Av7eN