Hi, :) :)
Could you please help.
I have to calculate Mode for a # of rows. I'm using the below calculation but it seems like the #s that are generated are much larger than the Mode.
maximum(running-count([Time_Interval])).
Is there a good calculation code to use for calculating the Mode?
Thanks a lot for your time!
Let me know if this helps
http://www-01.ibm.com/support/docview.wss?uid=swg21687273
Thank you Ray, I appreciate the information.
Getting the below error.
XQE-PLN-0174 The column Duration must be contained in an aggregate function or the GROUP BY clause.
CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2018-11-29-17:59:
I'm trying couple of things.
Thanks
Duration Data item is as following,
case
when [STEP_TYPE] in ('TV Processing') then
(_days_between([V_C_C],[V_C_O]) )
when [STEP_TYPE] in ('Paper Processing') then
(_days_between([A_C_1],[Q_B_1] ))
else
(_days_between([V_P_C],[V_P_OPEN]) )
end
Thanks
Issue resolved. I established a Detail Aggreg. so only one value is returned. Look good. Thanks so much!