calcualted dimension on stack bar

manoranjan_d — Thu, 16 Jun 2016 09:47:48 GMT

Hi above is my data.

In this I need to show bar chart for the dept for the FAIL ,in order to show the key count and amount .

so how to use the calculated dimension and for the dept for the FAIL and then the expression how to toggle between the record and dollar value

Re: calcualted dimension on stack bar

sunny_talwar — Thu, 16 Jun 2016 09:52:55 GMT

Check the attached

Expressions used:

1) =Count({<passfail = {'FAIL'}>} key)

2) =Sum({<passfail = {'FAIL'}>} amount)

When viewing count

When viewing Sum of amount