Having conditional count on columns

[#1]

Hi Experts,

I have a scenario as below.

There are orders in the system which will be at a STAGE for 'n' number of days.And for each stage there will be 'M' days given as SLA.

Now I would like to have a column  which gives me count of orders which have crossed the SLA.

ie, against each stage, I want the count of orders which has n>M.

Can some body pleeeease help me.

Many thanks in advance.

Lavanya

[#2]

Hi Lavanya,

here a first guess for your chart-expression:

count( if(STAGE > SLA, order))

Regards, Roland

[#3]

Thanks very much Roland.

Is it count(if(n>M, order)) ?

Because, STAGE is a stage at which Order is at.

I have tried it like this,

Dimension as STAGE_CODE and

Expression as count(if(n>M, order)) but it dint fetch me any result.

Thanks for your help once again.

[kaushiknsolanki]

Hi,

   Try this.

   Create a straight table.

   Add dimension as Stage.

   Add expression as count({<N = {">M"}>}Order)

Regards,

Kaushik Solanki

[#5]

Hi again,

this should work when 'n' and 'M' are fields belonging to the same table as 'STAGE_CODE' and 'order'. Or they are in a table with a link to the "order-table".

I am quite sure you (we)  are not far away from the solution, but to find the last missing part it would be very helpfull if you post a little exam app. This can explain more then any description.

RR

[#6]

Thanks Roland.

You are right. I got it as below.

count(if(NUMBEROFDAYS >=SLA, PAG_ID)).

Thanks Koushik, I am there with Roland's suggestion.

Now since I have got it, is it possible for me into include some range in 'IF' condition.

like  count( if ( n>m and n<p), pag_id) ?

I know I am just missing with small bit of logic..

Many thanks for your time and help.

Regards

Lavanya

[kaushiknsolanki]

Hi,

    Yes you can do that.

     If you want to achieve with set analysis. you will use below code.

    count({<N = {">M<P"}>}Order)

Regards,

Kaushik Solanki

[#8 · Accepted solution]

Hi Lavanya,

glad to help you.

To answer your second quest: Yes you can, but take care of the brackets:

count( if ( n>m and n<p), pag_id) 

---> should be: count( if ( n>m and n<p, pag_id))

This means that the if() delivers only those pag_ids to the count() which passed its filter.

RR

[#9]

Many thanks for your help Roland

Regards