Monthly Percentage of Complain

[Waqar]

Hi

I have a sheet where i record daily complains, I want monthly percentage of completed and pending complain.

There are four category of complain 1.Minor1 2.Minor2 3.Major1 4.Major2 (Last Column of the Sheet)

*Minor1 Complain which complete without financial expense within 4 days.
*Minor2 Complain which complete without financial expense more then 4 days.
*Mojor1 Complain which complete with financial expense within 10 days.
*Mojor2 Complain which complete with financial expense more then 10 days.

I want a solution so that i can find out monthly ratio of Minor1 Minor 2 Major1 Major2
example:: in Jan 2012 60% of Minor1 complain completed. :: in Feb 86% Major2 complain completed.

Regards

 

[Waqar]

I also want to share my data but unable find way......guide me how can i share data

 

[JavierGuillen]

you could send it to me: javiguillen@hotmail.com

 

[Waqar]

I send to you.
Plz check if u have any query then ask to me viz email
Regards

 

[JavierGuillen]

Hi Waqar

Where are your dates? are they rolled up with the complain column?

if your data is like this:

complain	complain status
2011-12-23-2256	Minor1
2011-12-27-2257	Minor1
2011-12-27-2258	Minor1
2011-12-30-2259	Minor1
2011-12-30-2260	Minor1
2011-12-30-2261	Minor1
2011-12-30-2262	Minor1
2011-12-30-2263	Minor2

<tbody>
</tbody>

you can add a calculated column like: (call it [Month])

=MONTH(LEFT([complain],10))

With this, you can now create a measure to get the % complete of Minor1, for example, as:


CALCULATE( COUNTROWS( Table1 ), ALLEXCEPT( Table1, Table1[Month] ), Table1[complain status] = "Minor1" ) / CALCULATE( COUNTROWS( Table1 ), ALLEXCEPT( Table1, Table1[Month] ) )

 

[Laurent C]

You could do something like that:
[# Completed in 4 days] := CALCULATE(COUNTROWS(YourData), FILTER(YourData, YourData[Complain completed in days] < 4))

 

[Waqar]

Thanks Alot Javier and Laurent

Can u both send me example sheet via mail
waqarqrl@hotmail.com

Regards