how to modify the expression based on the Calculated Dimension?

[#1]

Hi All,

Please help me solve the below issue.

I am creating a bar chart with 2 dimensions and one expression.

Dimensions are YearMonth and Site Name

Expression is count of field number.

in this chart, 2 more fields to be considered.

Fields Are 1) Description and 2) Receipt Issued?

condition is something like below:

If Description is Market withdrawal, then Site name should be appended with --Market withdrawal

If Site Name is 1, then Site name should be appended with --Receipt Sent

if none of the above conditions meet, then Site name should be appended with --Recall.

and the expression should count the Field Number, based on above dimension.

I tried this calculated Dimension:

=if([Description]='Market Withdrawal',[Site Name]& '  -' & 'Market Withdrawal', if([Receipt Issued?]='1',[Site Name]& '  -' & 'Receipt Sent',[Site Name] & '  -' & 'Recall'))

And below expression:

=if([Description]='Market Withdrawal',Count([Field Number]),

if([Receipt Issued?]='1',Count([Field Number]),Count([Field Number])))

But the count is not as expected.

if i try only below part of expression, count is proper

if([Description]='Market Withdrawal',Count([Field Number]),

if([Receipt Issued?]='1',Count([Field Number]))

Could someone please help me figure out what is going wrong here?

Can i avoid this calculated dimension and manipulate the expression to satisfy the requirement?

Thanks & regards

Jyothi

[#2 · Accepted solution]

just the Count([Field Number])) in the expression did the trick.