Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help
I have written an expression in my chart,
Count(distinct IF(CALL_REQ_OPEN_DATE < TIMESTAMP(CalendarMonthStart),
If(LEN(CALL_REQ_RESOLVE_DATE1)<1 or CALL_REQ_RESOLVE_DATE1 >TIMESTAMP(CalendarMonthStart),
IF(INCIDENT_STATUS<>'Cancelled' or (INCIDENT_STATUS='Cancelled' AND CALL_REQ_CLOSE_DATE >TIMESTAMP(CalendarMonthStart)),
CALL_REQ_REF_NUM))))
which causes delay in loading the chart,
Can someone suggest how to write it, so load on chart is less.
Hi,
The problem occures when you use the if statement in expression.
Cause If statement searches full record set and then gives you the answer.
I would suggest you to convert all your expression in set analysis.
This will for sure increase the performance of the chart,
Regards,
Kaushik Solanki
Hi Amay,
I could notice lot of if conditions used in almost all of your expressions, hence the delay in launching the chart for the first time. Once I save the file on to my local drive the I could not find any delay in launching. Alternatively you can use set analysis while defining your expressions, which can make your life easier.
Regards,
Raghav
Hello everyone,
I know I'm not a Community moderator, but I can't help bringing to your attention (and to any other users's attention including mine) the fact that this is the kind of post that doesn't invite me to help. I'll make myself clear: a post with a small line in the subject, with no other content than "Please help", and one file attached (a heavy one, so very difficult to download in some cases I should add) seems to me as the kind of "Here you are my job, do it for me" posts I've been avoiding helping on purpose.
Again, I'm not a moderator but another user, and I don't feel comfortable with these kind of posts. Actually, I've been tempted to mark this one as "Abuse".
So to all users of the Community that are accustomed to post these kind of things, please, provide the Community with some explanation on the actual issue, sample data, what do you expect to get?, what did you already try and how did that work?, was that working before and it stopped at some point?, what environment are you using?, etc... The more information you provide with, the better and faster the solution will come. Note that in fact no contributors are getting paid for answering and helping in the Forums.
In short, this is not the best way to attract people to your posts and make them help you.
Be considered with the others as you expect to be considered in return.
Regards, and sorry for the "helpless" post.
BI Consultant