Calculated Expression not displaying in Bar Graph

[brettaustin]

I want to create a bar graph that counts the total of sales types for each reporting period.  However I want to combine all the 'Include' records in one graph (stacked... but not separated by each 'sales type')

Report Period       SalesType

1                            Include

1                            Exlcude

1                            Include - Sale

1                            Include - Tax

1                            Include - credit

1                            Include - Coupon

1                            Exclude - Reject

1                            Exlcude - Feature

1                            Include - Salary

1                            Include - Salary

1                            Include - Salary

1                            Include - Salary

1                            Include - Salary

Desired End Result:

Include: 10

Exclude: 1

Exclude - Reject: 1

Exclude - Feature: 1

I tried creating separate expressions for each count but when I do this only 1 graph is displayed.  Please Help!

Exp1: =Count ({<SalesType={'Include','Include - Sale','Include - Tax','Include - credit','Include - Coupon'}>} SalesType)

Exp2:  =Count ({<SalesType={'Exclude'}>} SalesType)

[brettaustin]

Example of bar Graph not displaying correctly

[shiveshsingh]

You need calculated dimension

=if(WildMatch(SalesType,'Include*'),'Include',SalesType)

[sunny_talwar]

Would you be able to share your qvw file?

[shiveshsingh]

and expression will be count([Report Period])

[brettaustin]

could you please add the qvw?

[qv_testing]

Like this,

[shiveshsingh · Accepted solution]

pfa

[brettaustin]

Thank you!!!!

[shiveshsingh]

Glad to know it worked