expression help

[#1]

Hi,

This will be a simple I guess so apologies if it's rather basic.

With have a field in some data called 'responded to'. The possible answers are 'Y' and 'N' which have been populated in the fields.

On our app we want 2 charts - once showing breakdown of 'Y' by area and the other 'N' by area. The answer is an expression in the chart but we can't seem to get it right.

Can someone please help? Below is the expression we have. Its says its ok but its not reflecting the data.

Count([Responded to letter?] = 'Y')

Chris

[priyarane]

Count({<Respondtoletter = {'Y'}>})Field)

[#3]

Where you have 'Field' do we put something in there to replace that?

[priyarane]

So, what ever your counting.

For Ex:

Count for country

then Count(Country)

[awhitfield · Accepted solution]

HI Chris

=Count({<RespondedToLetter={Y}>}RespondedToLetter)

so you are counting the number of RespondedtoLetter where the value of that field = Y

Cheers

Andy

[#6]

Hi,

Try this,

IF(Responded to letter?] = 'Y',COUNT('Y'),COUNT('N')

Rgds,

Priyantha.