How to get the fail by week and fail by month? URGENT HELP please

[#1]

Hi,

I need to show the % of Fail by Week and % of Fail by Month. Can anyone help me please. As if we see the Member 'FR'. The 'FR' has % of Fail as 4.17% . so, my user is asking the same information if we take the dimension as Week.

Thanks.

[#2]

please see attached.

EDIT: I tried using the below

Dimension: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Expression :

=Count({<[Overall Result]={'Fail'}>} DISTINCT ID)/(Count({<[Overall Result]={'Pass'}>} Distinct (ID))+

Count({<[Add Overall Resilt]={'Pass'}>} Distinct (ID))+

Count({<[Overall Result]={'Fail'}>} Distinct (ID])))

but it is not showing correct values.

[yduval75]

Here the qvw

[MK_QSL]

Please check your data...

If you create a Straight Table with

Overall Result as Dimension

and

Count(Distinct ID) as Expression...

you will get result like

Fail  5

Pass 52

Pass 2

Why two Pass?

Looks like there are one extra space for pass against below two ID

F00565 and S02146

[PrashantSangle]

Hi,

Try this

=Count({<[Overall Result]={'Fail'}>} DISTINCT ID)/(Count({<[Overall Result]={'Pass'}>} Distinct ID)+

Count({<[Add Overall Resilt]={'Pass'}>} Distinct ID)+

Count({<[Overall Result]={'Fail'}>} Distinct ID))

Or

You can eliminate [Add Overall Resilt] field because you can get total ID by

Count({<[Overall Result]={'Pass'}>} Distinct ID) and

Count({<[Overall Result]={'Fail'}>} Distinct ID) expression

so you can

try this also,

=Count({<[Overall Result]={'Fail'}>} DISTINCT ID)/(Count({<[Overall Result]={'Pass'}>} Distinct ID)+

Count({<[Overall Result]={'Fail'}>} Distinct ID))

Regards,

PS

[#6]

Thanks. when I am clicking individual Member it is showing different data under Week

suppose if I click on FR the % of fail in Data table is showing as 4.17% whereas the % of Fail with dimension Week is showing as under 6th week as 14.29% . Is that correct ?

[#7]

Yes you are right. I created extra pass because of duplicate ID for different Dates.

[MK_QSL]

Sorry But can you explain in details what you want ?

[#9]

Thanks. I have a table with

Dimension: Member

Number Review

=(Count({<[Overall Result]={'Pass'}>} Distinct (ID))+

Count({<[Add Overall Resilt]={'Pass'}>} Distinct (ID))+

Count({<[Overall Result]={'Fail'}>} Distinct (ID])))

Number Fail =Count({<[Overall Result]={'Fail'}>} DISTINCT ID)

% of Fail= Number Fail/Number Review

Now my requirement is I need to show the % of Fail by Week and % of Fail by Month

I,e instead of dimension= Member I need Dimension= Week in one chart and Dimension=Month in another chart?

[#10]

Can you please tell me is that correct?