Doing a Count of Dimension

[#1]

Hi

Below i have a a sample of my data.

Voucher_Number	Decoder_Code	Claim_Date	Claim_Status
SD8 316785	V101391424	28/08/2013	Rejected
SD8 316785	V101391424	10/09/2013	Rejected
SD8 316785	V101391424	25/09/2013	Accepted
SD8 316785	V101391424	27/09/2013	Rejected

I want to create a straight table chart showing the count of claim status.

•      One column for Count of Rejection and Once column for Count of Accepted with only one dimension which should be the Voucher_Number.

The result im looking for should be as follows.

Voucher_Number	Rejected	Accepted
SD8 316785	3	1

[#2 · Accepted solution]

Hi

try this,

Dimension Tab: Voucher_Number

Expression Tab:

Rejected:

count({<Claim_Status = {'Rejected'}>}Claim_Status)

Accepted:

count({<Claim_Status = {'Accepted'}>}Claim_Status)

[#3]

Hi Alexis

Thank you. It worked.

Kind regards

Nayan

[#4]

You're welcome^^

[MayilVahanan]

HI

Try like this

=Count({<Claim_Status = {'Rejected'}>)Claim_Status)

=Count({<Claim_Status = {'Accepted'}>)Claim_Status)

[#6]

please close the thread by picking a correct answer